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
- 24193 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnan
a)in the first case there is no output only the column
names alone is displyed
b)in this case all rows will be displayed even for
1=1,2=2,3=3,..........
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a livelock?
How to disable stored procedure sql server?
how can you check the level of fragmentation on a table? : Sql server administration
Explain cross join or cartesian product in sql?
What are the differences between DDL, DML and DCL in SQL?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is RAID? What are the different types of RAID configurations?
wat wil hapn if we give the both read and deny read permission to user?
How do I save a stored procedure in sql server?
What are rows and columns?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What happens if you are trying to access a schema not owned by you?
What encryption security is available in sql azure?
Do I need a report server to run reports in my application?
How to get nth highest salary from employee table.
