what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 20684 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
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is trigger in salesforce?
What happens if null values are involved in arithmetic operations?
What happens if you are trying to access a schema not owned by you?
Does the unique constraint create an index?
What are a scheduled jobs or what is a scheduled tasks?
What types of Joins are possible with Sql Server?
How do I debug a stored procedure in sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How to view existing indexes on an given table using sp_help?
What the different topologies in which replication can be configured?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What are the export options of ssrs?
