what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answer Posted / m@ngesh
in the first query There is no records to show in output
box only show the column name Like empname, city, address
etc..
and the second query say that there is all records are to
be show.when query (1=1) will be satisfied on the table
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Do you know the different ddl commands in sql?
What is the default fill factor value?
Explain trigger and its types?
What is an index. What are the types?
What the different types of Replication and why are they used?
In which format does an image save in SQL Server database ?
What are information schema views?
What are cursors stored procedures and triggers?
What is the order in which the sql query is executed?
Explain what are the database objects? : SQL Server Architecture
What do you understand by mirroring and mention the advantages of the mirroring?
Differentiate between mongodb vs. Sql server?
Can you move the resources after pausing the node? : sql server database administration
What are the parts of a function?
How to identify current user in ssrs report?