Query to get max and second max in oracle in one query ?
Answer Posted / braulio
-- that's it
select * from
(select max(salary) from salary)
where rownum = 2
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to define an anonymous procedure without variables?
What is blob data type in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is a database table in oracle?
What are joins, explain all types of joins?
Is rowid unique in oracle?
What is the difference between alert log file and tarce file ?
Respected sir, Please send me technical questions related to oracle apps..
How many file formats are supported to export data?
How to use subqueries with the in operator using oracle?
What is an Oracle index?
How to execute a stored procedure in oracle?
How to generate query output in html format?
if you ctreate table identity
How to create a table in a specific tablespace?