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
Where is all the data on the internet stored?
What is coalesce in sql?
What is sql in oracle?
What is plpgsql language?
Can a table have no primary key?
what is blob? : Sql dba
Differentiate between pl/sql and sql?
What is nvarchar max in sql?
What are the advantages of stored procedure?
What is bind reference and how can it be created?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is difference between group by and partition by?
explain the difference between delete , truncate and drop commands? : Sql dba
What is pls integer?