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
- 24824 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / phani
In First case it will not return any rows. only the colum
names will be displayed.
In the second case all the records that are available in
the table will be displayed.
| Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
Difference between drill down and drill through report.
how many no of arguments can be passed in procedures and functions
Using the customer, and order table in northwind database, please write a query to produce xml?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to count duplicated values in a column in ms sql server?
How to find the service pack installed? : sql server database administration
How many clustered indexes there can be on table ?
How we can refresh the view?
What happens if ntwdblib.dll is missing on your machine?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What happens when converting big values to numeric data types?
Explain mixed authentication mode of sql server?
What is inner join? Explain with an example?
How can delete duplicate records in cte in sql server?
What are types of scd? : sql server analysis services, ssas
