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
- 24347 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
Explain different backup plans?
Write a query to find 5th highest amount paid from the customer table.
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How can you insert null values in a column while inserting the data?
What is t-sql script to take database offline – take database online.
What is identity?
how can a database be repaired? : Sql server administration
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Can we linked SharePoint to a SQL database?
List out the difference between union and union all in sql server?
What is a mixed extent?
Explain isolation levels that sql server supports?
Which are the third-party tools used in sql server and why would you use them?
What is SQL Azure Federations?
What is a trigger in sql server?
