select * from emp minus select * from emp;

sql query to get zero records from a table having n no of
records

Question Posted / xyz

Answer Posted / xyz

select * from emp minus
select * from emp;

Is This Answer Correct ?

12 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are all the different types of indexes?

1145

Why is a primary key important?

1036

How do I view tables in mysql?

976

What is t-sql? : Transact sql

980

Does sql between include endpoints?

994

What is a full join sql?

1051

Is sqlite good enough for production?

990

How can triggers be used for the table auditing?

1065

Why do we use joins in sql?

968

Can we join two tables without common column?

999

How does postgresql compare to oracle/db2/ms sql server/informix?

1029

What is the use of %rowtype?

1031

what is 'mysqlimport'? : Sql dba

1041

What are all types of user defined functions?

1071

What is sql dialect?

1108