how to retrieve only duplicate values in a table

Answer Posted / siva

Select* from emp where rowid not in(select max(rowid) from emp group by empno);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql built in functions?

489


What is a string data type in sql?

498


what is cursor. write example of it. What are the attributes of cursor.

717


How many databases can sql express handle?

505


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3201






What is row_number () in sql?

517


How are functions and procedures called in PL/SQL?

570


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

507


What does (*) mean in sql?

513


How to check if a column is nullable before setting to nullable?

566


Can primary key be changed?

501


How many types of triggers exist in pl/sql?

540


What is pl sql code?

563


can sql servers linked to other servers like oracle? : Sql dba

524


What are variables in pl sql?

545