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 is msql? : Sql dba

562

What is difference between db2 and sql?

530

What is pragma in pl sql?

597

Why do we use function in pl sql?

553

Who developed sql?

567

How do I truncate a word?

522

Can we join tables without foreign key?

520

Is there a 64 bit version of ssms?

516

Is clustered index a primary key?

527

What is dialect in sql?

525

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

573

Can a procedure in a package be overloaded?

544

Why truncate is faster than delete?

558

What is scalar function in sql?

529

When should I use nosql database?

551