How to get / select the nth row from the table?
how to select first n rows ,last n rows from a table?
Submitted by: Administratornth salary
select salary
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
n salaries
select salary
from table_name a
where &n>=(select count(salary) from table_name b where a.salary<=b.salary);
select level,max(column name) from emp where level = n connect by prior sal > sal group by level;
Submitted by: Administrator
select salary
from table_name a
where &n=(select count(salary) from table_name b where a.salary<=b.salary);
n salaries
select salary
from table_name a
where &n>=(select count(salary) from table_name b where a.salary<=b.salary);
select level,max(column name) from emp where level = n connect by prior sal > sal group by level;
Submitted by: Administrator
Read Online Oracle D2K Job Interview Questions And Answers
Top Oracle D2K Questions
| ☺ | What is oracle d2k? why we use it? |
| ☺ | What is the Placeholder Column? |
| ☺ | How I can use SRW.RUN_REPORT in Reports6i? |
| ☺ | What is the Page Protect in Reports? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
