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 difference between hql and sql?

0 Answers  

Compare SQL and PL/SQL.

3 Answers  

What is acid property in a database?

0 Answers  

What is a unique key?

0 Answers  

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

How do I run sql?

0 Answers  

Are subqueries better than joins?

0 Answers  

What is a recursive stored procedure?

0 Answers  

What are the packages in pl sql?

0 Answers  

What is sqlerrm?

0 Answers  

what is a composite key ? : Sql dba

0 Answers  

how to get a list of all tables in a database? : Sql dba

0 Answers