a query to select maxmun 3 salaries of employee table
Answers were Sorted based on User's Feedback
Answer / neo devan
select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));
Is This Answer Correct ? | 0 Yes | 4 No |
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
How to create a table in a specific tablespace?
State and explain the different types of data models?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
What different of iner joint & outer joint with example
What is the difference between sharding and replication?
What is an oracle function?
How to write date and time literals in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is a cursor variable?
How to shutdown your 10g xe server?
What is the best way to do multi-row insert in oracle?