find out the third highest salary?
Answer Posted / nehal
select e.sal from employee where n-1=(Select count(distinct
sal) from emp where sal>e.sal)
Put n=3 for the 3rd highest salary.
Is This Answer Correct ? | 10 Yes | 7 No |
Post New Answer View All Answers
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain do view contain data?
Explain database link?
How to do a full database export?
How to use "in out" parameter properly?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to use windows user to connect to the server?
WHAT IS ecc 6.0
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the order of defining local variables and sub procedures/functions?
How to assign values to data fields in record variables?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to find out what oracle odbc drivers are installed?
How to execute a stored program unit?