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
- 24318 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / sailaja
Hi,
select * from EMP where null=null;
->null=null is always false so it gives 0 records.
if it is null is null then it fetches all the records in a
table..
select * from EMP where 1=1;
->it fetches all the records in a table
if it is select * from EMP where 1=2;
-->it fetches 0 records..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the reporting service components in SSRS?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How many servers can we create in a single subscription?
What is an index. What are the types?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is the sql case statement used for?
Can sub report data source be different from that of the parent report?
What is rank function?
Explain different forms of normalization?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are the different editions available in sql server 2000?
Give me a SQL Query to find out the second largest company?
What is the difference between web edition and business edition?
Mention the different types of replication in sql server.
What is the cpu pressure?
