Interested to Buy Any Domain ? << Click Here >> for more details...
what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 24321 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / phani
In First case it will not return any rows. only the colum
names will be displayed.
In the second case all the records that are available in
the table will be displayed.
| Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
How to generate create table script on an existing table in ms sql server?
Can sql servers linked to other servers like oracle?
Tell me what is difference between clustered and non clustered index?
What is advantage data architect?
Is sql server is free?
What are the advantages of sql stored procedure?
Explain the difference between functions and stored procedures in sql server?
What is the rdl file?
What are the advantages of mirroring?
how will add additional conditions in sql?
What are the restraints imposed on the table design by a merge replication?
Explain the different types of backups available in sql server? : sql server database administration
What is an indexing strategy?
Why I have to use stored procedures?
How can we delete a table in sql server?
