what is the output of this query selet * from employee
where 1=2 ??

Answer Posted / priyanka agarwal

It will return 0 rows as 1 will never be ewual to 2

Is This Answer Correct ?    50 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a sql query to get the third highest salary of an employee from employee_table?

625


What are sql triggers used for?

503


How to get each name only once from an employee table?

602


Does sql view stored data?

528


what is datawarehouse? : Sql dba

562






Define SQL and state the differences between SQL and other conventional programming Languages?

676


Is the primary key an index?

589


Do foreign keys improve performance?

541


how can we destroy the cookie? : Sql dba

550


What is PL/SQL Records?

619


What is the difference between between and in condition operators?

529


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

594


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

536


how is exception handling handled in mysql? : Sql dba

546


Show how functions and procedures are called in a pl/sql block.

584