how u can find the n row from a table?
Answers were Sorted based on User's Feedback
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 ? | 30 Yes | 5 No |
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 |
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 |
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 |
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 |
Answer / santosh dwivedi
select * from
(
select rownum r,a.* from TableName a
)
where r=n'th
Is This Answer Correct ? | 5 Yes | 4 No |
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 |
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 |
Answer / pradeep
try this works in mysql
select * from table_name limit n-1,1;
Is This Answer Correct ? | 1 Yes | 0 No |
select * from employees where rownum<=&nth_row
/
Is This Answer Correct ? | 0 Yes | 0 No |
What is data type in sql?
what is blob? : Sql dba
How to select 10 records from a table?
What is sqlerrd?
How to avoid using cursors?
How much does a sql dba make? : SQL DBA
Can a foreign key be a duplicate?
Why do we create stored procedures & functions in pl/sql and how are they different?
Is sql pronounced sequel or sql?
How does join work in sql?
How do I start pl sql?
describe mysql connection using mysql binary. : Sql dba