If you want nth record from table employee then.. select * from employee

how u can find the n row from a table?

Question Posted / rama krishna

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

Answer Posted / rama krishna

If you want nth record from table employee then..

select * from employee where rownum <= n
minus
select * from employee where rownum < n

the above query will suffice.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we join same table in sql?

1003

What is the max nvarchar size?

947

What are sql*plus environment variables?

1077

What is the difference between partition and index?

971

Can I create table without primary key?

983

What is lookup table in sql?

1024

What is #table in sql?

1071

What are the properties of a transaction?

1121

Explain the difference in execution of triggers and stored procedures?

1003

How does sql profiler work?

1004

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1026

What is benefit of creating memory optimized table?

958

Is ms sql is free?

1010

What is a call statement? Explain with an example.

993

Is crud a cuss word?

1017