How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
Answers were Sorted based on User's Feedback
Answer / madhavi
SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
Is This Answer Correct ? | 1 Yes | 2 No |
what are stored procedures?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
What are the various oracle database objects?
What are temporal data types in oracle?
What is a Temporary Segment ?
How many memory layers are in the oracle shared pool?
What is the sql query to concatenate column values from multiple rows in oracle?
How to restrict the duplicate records in table valuesets
How to define an external table with a text file?
Explain the use of consistent option in exp command.
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.