Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 87701 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
that will return 2nd highest salry .if we place insted of 1
as 2 then we can get 3 rd highest salary .
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to use "startup" command to start default instance?
What happens if you set the sga too low in oracle?
Is oracle a language?
What privilege is needed for a user to query tables in another schema?
How to download oracle database 10g xe?
Explain about functional dependency and its relation with table design?
Explain what are the advantages of views?
How to assign query results to variables?
How to do a full database export?
Please explain compound trigger in oracle?
How can I see all tables in oracle?
How to define a data field as not null?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to convert dates to characters in oracle?
