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
- 24202 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan
a) first statement return only table structure (with out
data)
Eg: empid empname
b) second statement return the structure with data.
Eg: empid empname
101 radha
102 krishnan
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between count and distinct count?
How to delete duplicate rows in sql server?
what are the important architecture components of SSRS?
How can you list all the columns in a database?
What is the downside of using udf?
How to create a view using data from another view?
Can you pass expressions to stored procedure parameters?
Explain ms sql server reporting services vs crystal reports?
What is 1nf normalization form?
Can we deploy SSRS reports on our personal website?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Do you know what is normalization of database? What are its benefits?
How to delete database objects with "drop" statements in ms sql server?
How are the unique and primary key constraints different?
Explain about Joins?
