what is the output for this query
select * from employee where 1=1;

Answer Posted / mohanakrishna

The querry display the total table information present in
the database.

EID ENAME MID
101 rama null
102 sita 101
103 siva 101
104 ganesh 103

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2174


What is Federation Root Database?

92


How to add more data to the testing table in ms sql server?

643


Explain primary key in sql server?

660


How to find out what is the default collation in a database?

713






Can we call future method from trigger?

602


What is the downside of using udf?

656


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

92


How and why use sql server?

632


What is difference between joins and subqueries?

622


What is standby servers? Explain types of standby servers.

594


What is resource governor?

630


What are the different types of stored procedures?

661


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

650


State a few properties of relational databases?

756