Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
- 6 Answers
- 8239 Views
- I also Faced
- E-Mail Answers
Answer Posted / hema
Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What do you mean by a tablespace?
How do I call oracle stored procedures that take no parameters?
What is set verify off in oracle?
What are the differences between blob and clob in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Can group functions be mixed with non-group selection fields?
How to get a create statement for an existing table?
What is the string concatenation operator in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What are the uses of a database trigger?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to use existing values in update statements using oracle?
How do you bind variables in oracle?
Explain the use of constraints option in exp command.
