How to Select second Maximum salary in a Table ?
Answers were Sorted based on User's Feedback
Answer / 9896012055
select * salary from table < select max(salary) from table
order by salary;
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / havyas
select sal from table where rownum = 2 order by sal desc
Is This Answer Correct ? | 1 Yes | 13 No |
what is candidate key & super key
what is normalisation?what are its uses?
How to start a new transaction in oracle?
How to create a new view in oracle?
When does a Transaction end ?
Can we write dml statement in function in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What do you mean by merge in oracle and how can we merge two tables?
Explain the use of rows option in exp command.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is oracle open database communication (odbc)?