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
- 8385 Views
- I also Faced
- E-Mail Answers
Answer Posted / esakkiraja
select a.* from(select dense_rank() over(order by sal)as
new_rank from emp) a where new_rank=2
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to drop a tablespace?
How to count duplicated values in a column in oracle?
What is a server parameter file in oracle?
How do you bind variables in oracle?
What are the components of logical database structure in oracle database?
How to use subqueries with the in operator using oracle?
How to find out what oracle odbc drivers are installed?
How to load excel data sheet to oracle database
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to start your 10g xe server?
What is a data lock in oracle?
How to load data through external tables?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is an anonymous block?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
