Answer Posted / vasu
select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the relation of a user account and a schema?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain what does a control file contain?
Define oracle database
State the difference between a primary key and foreign key?
How many types of tables are there in oracle?
Can you assign multiple query result rows to a variable?
What happens if variable names collide with table/column names?
What is set operator oracle?
How to get last row id?
What privilege is needed for a user to delete rows from tables in another schema?
What is an oracle cursor variable?
Explain user account with reference to oracle.
What is an oracle database table?
Oracle