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).....

Answer / pardeep rajan

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

Answer / manish singhania

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

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

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.

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...

Answer / santosh dwivedi

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

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

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;

Answer / pradeep

try this works in mysql

select * from table_name limit n-1,1;

Answer / abhishekjaiswal

select * from employees where rownum<=&nth_row
/

What is asqueryable?

0 Answers  

Explain spool.

0 Answers  

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

How do you exit in sql?

0 Answers  

What is inner join in sql?

0 Answers  

Is left join same as inner join?

0 Answers  

Is merge a dml statement?

0 Answers  

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

in procedure how to return a value

3 Answers   Wipro,

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers