how u can find the n row from a table?
Answer Posted / guest
select rownum,ename,sal,empno from(select ename,sal,empno from
table_name order by sal) group by rownum,ename,sal,empno
having rownum=(select count(*) from table_name
Is This Answer Correct ? | 10 Yes | 13 No |
Post New Answer View All Answers
What are sql queries used for?
What is record type in pl sql?
what is sub-query? : Transact sql
How does sql profiler work?
How do I truncate a sql log file?
Can we use ddl commands in pl sql?
What do you understand by pl/sql cursors?
is it possible to pass an object or table to a procedure as an argument?
How to call shell script from pl sql procedure?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Explain what is a view?
What are the two types of cursors in pl sql?
what is the difference between char and varchar data types? : Sql dba
Are stored procedures faster than dynamic sql?
Why do we create stored procedures & functions in pl/sql and how are they different?