find out the third highest salary?
Answer Posted / neha
select max(sal) from emp where sal <(select max(sal)from emp
where sal<(select max(sal) from emp));
Is This Answer Correct ? | 103 Yes | 31 No |
Post New Answer View All Answers
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What do you understand by a database object?
How to write a query with an inner join in oracle?
Explain cascading triggers.
Difference between inner join vs where ?
How to initialize variables with default values?
How can you use check constraints for self referential integrity?
Explain the use of compress option in exp command.
How to connect to the server with user account: sys?
Differentiate between function and procedure in oracle.
How to drop an existing table in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is a relational database management system?