Answer Posted / alok narayan
1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is the difference between nested subquery and correlated subquery?
What are the types of sql commands?
Can we use having without group by in sql?
When is the update_statistics command used?
What are types of exception?
What is the location of pre_defined_functions.
What are the types of variable use in pl sql?
How many row comparison operators are used while working with a subquery?
How is sql used in oracle?
What are crud methods?
Is oracel sql developer written in java?
What is data type in database?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is rowtype?
Who is the owner of mysql database?