find out the second highest salary?
Answer Posted / v.karthikeyan
select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)
| Is This Answer Correct ? | 62 Yes | 30 No |
Post New Answer View All Answers
What is a Garbage Collection? and what is full recursive Garbage collection?
What are the different editions of oracle?
What are the differences between date and timestamp in oracle?
What is difference between sid and service name in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Are truncate and delete commands same? If so why?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Explain oracle’s server parameter file.
What is a subquery?
How to get execution path reports on query statements?
What is a database schema in oracle?
How do I connect to oracle database?
what are the advantages of running a database in archive log mode?
How to commit the current transaction in oracle?