what eliminate duplicate without using roenum and not

Answer Posted / sathish

Use Group clause and having count < 2

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain the difference between myisam static and myisam dynamic. : Sql dba

513


What is the usage of nvl function?

594


Why query optimization is needed?

515


How to raise user-defined exception with custom sqlerrm ?

678


what are the advantages a stored procedure? : Sql dba

544






Why is stored procedure faster than query?

488


What is primary and foreign key?

591


What is the difference between inner join and natural join?

508


What is cross join example?

550


What is sqlca in powerbuilder?

563


What are the events on which a database trigger can be based?

592


What is character functions?

555


What is sql deadlock?

562


Explian rowid, rownum? What are the psoducolumns we have?

567


Does sql*plus also have a pl/sql engine?

558