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 the most important characteristics of pl/sql?
Differentiate between % rowtype and type record.
Which is better join or inner query?
What is the starting oracle error number?
Is ms sql is free?
What are aggregate and scalar functions?
Can we use insert statement in function?
What is a full join sql?
What is the sql case statement?
What is the usage of the distinct keyword?
what are the t string functions available in tsql? : Transact sql
What is procedure explain with example?
explain the difference between bool, tinyint and bit. : Sql dba
What is a table in a database?
Why we use joins in sql?