what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 20610 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
What is difference between rownum and row_number?
What are the different authentication modes in sql server? How can it be changed?
Explain the difference between cross join and full outer join?
Does order by actually change the order of the data in the tables or does it just change the output?
What is the difference between indexing and hashing?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is a non equi join?
How do you migrate data from mssql server to azure?
What are the different types of triggers in SQL SERVER?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Is sql server implemented as a service or an application? : Sql server database administration
Explain transaction server auto commit?
What is standby servers? Explain types of standby servers.
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Why truncate is ddl command?
