a query to select maxmun 3 salaries of employee table
Answers were Sorted based on User's Feedback
Answer / neo devan
select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 4 No |
How to empty your oracle recycle bin?
Which Oracle App Is Most Popular One ?
What is Java Pool in Oracle?
How to export your own schema?
Explain cascading triggers.
Is it possible to enter only time value into a column of a table in sql?
How many memory layers are in the shared pool?
What is Index Cluster ?
How many file formats are supported to export data?
What is a named program unit?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
What is a package ? What are the advantages of package ?