how to check the 3rd max salary from an employee table?
Answer Posted / akula
select min(sal) from(select distinct(sal) from emp order by sal desc) where rownum<=3;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is nosql relational?
What do you understand by case manipulation functions?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is pl sql block in dbms?
what is the syntax used for partition in tsql? : Transact sql
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Explain what is a column in a table?
How do I view a sql database?
What types of commands can be executed in sql*plus?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Explain the uses of control file.
what is msql? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Difference between truncate, delete and drop commands?
How do you create a db file?