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
- 23794 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 are the types of lock supported by ?
What are different types of database indexes?
What is your recommendation for a query running very slow? : sql server database administration
Explain what is lock escalation and what is its purpose?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
what is the difference between Tabular and Matrix report?
How to assign new column names in a view?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Define cross join in sql server joins?
What is lock escalation? : sql server database administration
How many types of subqueries are there in sql server?
Explain linked server in sql?
Explain concepts of analysis services?
What is truncate table?
What are different types of constraints?
