How to Select second Maximum salary in a Table ?
Answers were Sorted based on User's Feedback
Answer / 9896012055
select * salary from table < select max(salary) from table
order by salary;
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / havyas
select sal from table where rownum = 2 order by sal desc
| Is This Answer Correct ? | 1 Yes | 13 No |
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
what is dynamic SGA and static SGA
How to export your own schema?
How to name query output columns in oracle?
What is clustered table in Oracle?
State the various uses of dbcc command?
How to define Data Block size ?
12. Display the client name in upper case only and in lower case only.
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
How to run create database statement again?
Who developed oracle & when?
what is a cartition product?