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
- 24383 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / poonam
First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a with(nolock)?
What does set rowcount do?
Explain what is raid and what are different types of raid levels?
Can we perform backup restore operation on tempdb?
How to generate create table script on an existing table in ms sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Explain how would you store your query in an SSRS report or a Database server?
Why use view instead of a table?
mention different types of relationships in the dbms?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is normalization? Explain different forms of normalization?
How to rebuild indexes with alter index ... Rebuild?
Write a program using SQL queries to find a unique entry in a table.
What is the purpose of self join?
Comment,Datatypes are unlimited
