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

what is self-join? : Sql dba

573


What is difference between mysql and postgresql?

519


What is an example of translating a date into julian format?

582


How can you load microsoft excel data into oracle? : aql loader

618


What is structural independence and why is it important?

551






What is a full join?

530


What does the file extension accdb stand for?

549


How does pl sql work?

528


What does dml mean?

547


What type of database is sql?

615


What is multiple partition?

541


Explain the working of primary key?

614


What's the procedure?

492


Is truncate ddl or dml?

545


What are the triggers associated with image items?

621