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
- 23790 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / m@ngesh
in the first query There is no records to show in output
box only show the column name Like empname, city, address
etc..
and the second query say that there is all records are to
be show.when query (1=1) will be satisfied on the table
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sql server used for?
If the job running very slow what is the action you do
Where is trigger in sql server?
Explain primary key in sql server?
How to concatenate two character strings together?
how to trace the traffic hitting a sql server? : Sql server database administration
What are the steps to process a single select statement?
How do I determine how many instances of sql server are installed on a computer?
What is apply operator in sql?
Explain the difference between function and stored procedure?
Indexes are updated automatically is the full-text index also updated automatically?
What are the acid properties?
Can we update data in a view?
In how many ways you can invoke ssrs reports?
Name few of the dcl commands in sql?
