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
- 23797 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
If no size is defined while creating the database, what size will the database have?
How do you open a cluster administrator?
Mention the different authentication modes in sql server.
What are the dis_advantages of stored procedures, triggers, indexes?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is plan freezing?
How to replace the Query Result 'Null Value' with a text ?
How do you set a trace flag in sql server?
Why we use trigger in sql server with example?
What does it mean to normalize a database and why would you do it?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is SubQuery in SQL Server 2008
How to execute a stored procedure in ms sql server?
How to retrieve error messages using odbc_errormsg()?
Explain various data region available in ssrs with their use?
