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

Answer Posted / amit kumar

here...retrieve all column and records of employee. and
there is condition 1 = 1 is always true if 1 value in any
column.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a table have 2 foreign keys?

499


What do you understand by triggers?

514


what are cursors? : Sql server database administration

509


Explain the commands in sql server?

542


What do you understand by the denormalisation?

547






How would you add a section to a table?

562


What are the difference between “where” and “having” clause in sql server?

577


What is Command line parameters in PLSQL.?

578


Explain the benefits of user-defined functions?

518


How do I run a trace in sql server?

496


When I run the sql server 2000 setup, it just hangs. What do I do?

644


Define Joins?

605


What is failover clustering overview?

581


How many types of schemas are there?

521


How to make conditional sum in ssrs?

128