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

Answer Posted / xyz

select * from emp minus
select * from emp;

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

does sql support programming? : Sql dba

790


How you improve the performance of sql*loader? : aql loader

742


How do you use a while loop in pl sql?

706


What is the difference between between and in condition operators?

718


What is sql keyword?

751






what is foreign key? : Sql dba

743


What are joins in sql?

713


what is a constraint? Tell me about its various levels. : Sql dba

730


How to use transactions efficiently : transact sql

759


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1887


How to run sql functions in pl/sql?

719


What are primary key and foreign key and how they work?

739


Can we perform dml on view?

735


what is a join? : Sql dba

761


What are the commands used in sql?

731