select rownum,ename,sal,empno from(select ename,sal,empno from table

how u can find the n row from a table?

Question Posted / guest

19 Answers
29529 Views
Tech Mahindra, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to display Row Number with Records in Oracle SQL Plus?

1047

What are the advantages of sql? Explain

1107

What are sql triggers used for?

996

What is foreign key in sql with example?

937

What is the mutating table and constraining table?

1026

Who developed sql?

1049

What is attribute indicator in pl sql?

1015

What is meant by <> in sql?

979

What is the use of sqldataadapter?

975

how to get help information from the server? : Sql dba

942

What are the two types of exceptions.

1171

What is multiple columns?

1069

Is mariadb a nosql database?

1055

How long it takes to learn pl sql?

1011

What are the different types of a subquery?

1051