what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
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 cube dimension? : sql server analysis services, ssas
What are the built in functions in sql server?
Explain the third normal form(3nf)?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What does the on delete cascade option do?
Which command is used for user defined error messages?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is a db view?
Show Practically Sql Server Views are updatable?
What type of Index will get created after executing the above statement?
Define model database?
What is difference between rownum and rowid?
What is tabulation?
What is an indexing technique?
How can you control the amount of free space in your index pages?