what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 21459 Views
- Patni, I also Faced
- E-Mail Answers
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
What are the different types of stored procedures?
Where is my database stored on the hard disk in ms sql server?
Explain collation?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What are the steps to follow to configure SQL*Net?
What is join query?
What is the language structure to add a record to a table?
What is difference between aggregate and analytic function?
What are the advantages of using stored procedures in sql server?
What is a not null constraint?
Explain security with sql azure?
How many categories of data types used by sql server?
What is dknf in normalization form?
What is table level trigger?
which table keeps the locking information? : Sql server administration
