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

Does sql between include endpoints?

1060

What is a loop in sql?

1036

Why do we use procedures in pl sql?

1073

How is data stored on a disk?

1082

What is the limitation on the block size of pl/sql?

1037

What is online transaction processing (oltp)?

1063

explain the difference between bool, tinyint and bit. : Sql dba

1063

What are the advantages of sql? Explain

1153

What is the difference between nested table and varray?

1050

What is the use of desc in sql?

1019

What is materialized view. What are different methods of refresh?

1438

Can we change the table name in sql?

1000

How subquery works in sql?

1128

Can pl sql procedure have a return statement?

1072

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

1265