neelvizhi,
Did you mean is it advisable to change the format? Or do you want to know how to do it?
Please explain bit further.
Regards,
Type: Posts; User: SQLTweety; Keyword(s):
neelvizhi,
Did you mean is it advisable to change the format? Or do you want to know how to do it?
Please explain bit further.
Regards,
Did you mean is it advisable to change the format? Or do you want to know how to do it?
Please explain bit further.
Regards,
Did u verify before Altering the table taht there are no records in table with NULL RollNumbers?
Keep searching the forums of your interests . Try to interact with the members here , and the most important of all Keep Posting your queries.
Keep reinventing :)
Regards,
Do you mean data consistency across tables in the databases???
Sunil ,
Did you mean that you want fetch records only for perticular month / year / day?
If yes,
To get the records for for perticular month
Select * from my_table where...
Well said yogi.
Keep up the spirit.
Regards,
Keep Urself updated always , keep working hard and Keep praying.
And share ur success stories with us.
All the best.
IN clause is generally used to return values which are used as parameters for selecting another set of records. As follows
SELECT emp_name FROM employees where emp_id IN ( select emp_id FROM...
Hey ,
One thing about SQL Full Text Searches is it aids linguistic searches.
HTH :)
Regards,
One thing about SQL Full text searching is that aids linguistic searches in SQL server.
HTH :)
Regards,
Yes, Unique + NOT NULL is equivalent to primary key on a table ,though not explicitly declared. U can always use this column to retrieve a unique row from given table.
HTH :)
Regards,
Glad I could help :)
Keep inventing.
Regards.
Where DELETE statement deletes rows from table matching specifications in WHERE clause .
TRUNCATE deallocates memory page(s) allocated for the specific table in memory and hence it is a DDL...
Outer joins are generally used to retrieve data from one table thoug there is no matchind row in left or right table.
You can access this link for Further information
...
Sutnarcha , barbies query will give you correct results no doubt .
But VCyogi has given you a generic / more flexible query with wich you can get n-th higest / lowset salaray. It is just the...