find out the third highest salary?
Answer Posted / sanil
select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is the sql query to concatenate column values from multiple rows in oracle?
Explain database link?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is bind variable in oracle 11g?
How to select all columns of all rows from a table in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What do you mean by a tablespace?
What is java oracle used for?
What are dml statements in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is a snapshot in oracle database?
What is system global area (sga) in oracle?
What is a data dictionary and how can it be created?
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.
How do I spool in oracle?