Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how u can find the n row from a table?

Answers were Sorted based on User's Feedback



how u can find the n row from a table?..

Answer / santosh kumar

SELECT EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;

---------------------------------------------
(This is easy method to find nth record from a table).....

Is This Answer Correct ?    29 Yes 5 No

how u can find the n row from a table?..

Answer / pardeep rajan

kindly give a delete option for the users to delete wrong
answer. administrator also should verify the answers regularly

Is This Answer Correct ?    25 Yes 3 No

how u can find the n row from a table?..

Answer / manish singhania

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

n=1,2,......so many

Is This Answer Correct ?    4 Yes 0 No

how u can find the n row from a table?..

Answer / 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

how u can find the n row from a table?..

Answer / rishab

select emp_name,salary,rownum from
(select emp_name,salary,r from
(select salary,emp_name,rownum r from
(select salary,emp_name,rownum
from emp
order by salary desc)
order by r)
where r<4 ---- this number must be n+1
order by salary)
where rownum=1;
-- yes rownum=1 works...

Is This Answer Correct ?    4 Yes 3 No

how u can find the n row from a table?..

Answer / santosh dwivedi

select * from
(
select rownum r,a.* from TableName a
)
where r=n'th

Is This Answer Correct ?    5 Yes 4 No

how u can find the n row from a table?..

Answer / guest

select rowid,[optional columns...] from table where
rowid='n';
--n would be the input from the user which will let you
identify the row number of that particular record

Is This Answer Correct ?    1 Yes 0 No

how u can find the n row from a table?..

Answer / vijayshanker

SELECT EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID
FROM (SELECT ROWNUM
R,EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID FROM EMPLOYEES) A
WHERE A.R=&Record_Number;

Is This Answer Correct ?    1 Yes 0 No

how u can find the n row from a table?..

Answer / pradeep

try this works in mysql

select * from table_name limit n-1,1;

Is This Answer Correct ?    1 Yes 0 No

how u can find the n row from a table?..

Answer / abhishekjaiswal

select * from employees where rownum<=&nth_row
/

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

Why do we need sharding?

0 Answers  


Can we write dml inside a function in sql server?

0 Answers  


Can we perform dml on view?

0 Answers  


Write a query to get last 10 records from the table.

12 Answers   iNautix,


What are the PL/SQL Statements used in cursor processing ?

4 Answers  






What does dml mean?

0 Answers  


Is record in pl sql?

0 Answers  


Can two tables have same primary key?

0 Answers  


How long does it take to learn pl sql?

0 Answers  


How do I run a sql trace?

0 Answers  


How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


what are local and global variables and their differences? : Sql dba

0 Answers  






Categories