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
- 24823 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
Can sql server 2016 run on windows 7?
What is db stored procedure?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Tell me the phases a transaction has to undergo?
Can we hide the definition of a stored procedure from a use?
What is an active database?
Explain filtered indexes benefits?
Explain about the command-line tool SQLCMD?
What is a trace frag?
Can a trigger be created on a view?
How to delete duplicate records based on single column from a table?
How to disable a login name in ms sql server?
Where do you find the default Index fill factor and how to change it?
What are the tools available in market as an alternative to sql server reporting services?
How to create a scrollable cursor with the scroll option?
