what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answer Posted / poonam
First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where can you add custom error messages to sql server?
What are user defined functions in ms sql server?
What is 2nf in normalization?
What is application role in sql server database security? : sql server security
What guidelines should be followed to help minimize deadlocks?
What stored by the msdb?
What does it mean to manipulate data?
Explain foreign key in sql server?
How do you create type- insensitive operator?
What are the results of running this script?
What is the recovery model? List the types of recovery model available in sql server?
How do you migrate data from mssql server to azure?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the purpose of Normalisation?
How to make conditional sum in ssrs?