Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9406 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / sonthosh
SELECT * FROM
(
SELECT
NAME
,SALARY
,RANK() OVER (order by salary desc) RANK
FROM EMPLOYEE)
WHERE RANK = 2
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
How to define and use table alias names in oracle?
What is the usage of control file in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How can I introduce multiple conditions in like operator?
How to get a create statement for an existing table?
How to rename a tablespace in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
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
How to create tables for odbc connection testing?
How a tablespace is related to data files?
what is the scripts in data base?
What do you mean by merge in oracle and how can we merge two tables?
How to insert a record into a table?
How to open and close an explicit cursor in oracle?
What is oracle update statement with inner join ?
