DBMS Query

how to get the 4th largest record from the table.

We can use Row_number function(In SQL SERVER) to get the 4th highest.

Can you please post the query?

select * from
(select *,Row_number() over (order by Amount desc) as RowNumber
from FactFinance) A
where RowNumber =4

In the above mentioned query FactFinance is the table.
Amount is one of the column and I am trying to get the 4th highest amount in this table.
For doing so in the inner query you include the row_number function and in the outer query you can use the RowNumber column to get the 4th highest value.
If you still have any doubt please let me know.

Is Row_number function availabe to Oracle/DB2/MySql database also.?

for oracle you can use below query:-
select emp_id from (select rank() over (order by emp_id desc) r , emp_id from emp)
where r=4

Here table name is emp and column name is emp_id.It will give the 4th largest emp_id.