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
- 24407 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
Do you know how to implement service broker?
How do I view a script in sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Can we use where and having clause together?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is command parameter in ssrs?
Explain the benefits of user-defined functions?
What is instead of trigger sql server?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Name few endpoints exposed by ssrs 2012?
What is bit data type?
How network traffic be reduced by using the stored procedure?
How to loop through result set objects using odbc_fetch_row()?
What are the different normalization forms?
How to find the second highest salary of an employee?
