what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 20696 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / subbu
1st Query Output is:
SQL> select * from Emp where null = null;
no rows selected
2nd Query Output is:
All the rows and columns of emp table
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
Can a synonym name of a table be used instead of a table name in a select statement?
How to delete existing triggers using "drop trigger"?
Determine how to use the inserted and deleted pseudo tables?
What is the simplest way to create a new database in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is after dml trigger?
What are the different types of replication are there in sql server 2000?
What are the advantages of using stored procedures in sql server?
How many cores do I need for sql server 2016?
What do you know about normalization and de- normalization?
What is a rollup clause?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain the phases a transaction has to undergo?
Explain what is lock escalation?
How to find the service pack installed? : sql server database administration
