write a query to Find the Maximun second value in table?
Answer Posted / kd
select sal
from
(selec sal, row_number () over (order by sal desc nulls
last) as rnk
where rnk = 2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between dbms and rdbms?
What is system catalog or catalog relation?
what are the two integrity rules used in DBMS?
What does rdbms stand for?
What is dbms used for?
What is environment of openedge?
What are the two types of database?
what are the differences between an exclusive lock and a shared lock?
Mention the differences between unique key and primary key
What is advantages of progress actional?
What is called dbms?
What is instance in dbms?
What is a php database?
What are stored procedures in a database?
Explain the main control blocks available in ims db?