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
What are sql built in functions?
What is a string data type in sql?
what is cursor. write example of it. What are the attributes of cursor.
How many databases can sql express handle?
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
What is row_number () in sql?
How are functions and procedures called in PL/SQL?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What does (*) mean in sql?
How to check if a column is nullable before setting to nullable?
Can primary key be changed?
How many types of triggers exist in pl/sql?
What is pl sql code?
can sql servers linked to other servers like oracle? : Sql dba
What are variables in pl sql?