how to retrive only second row from table?
Answers were Sorted based on User's Feedback
Answer / kishan kumar
select empno,ename,sal,comm,job,mgr,deptno from emp
group by empno,ename,sal,comm,mgr,deptno,rownum
having rownum in (2);
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kishore.p
select top 1 * from tblemp b where b.empsal not in(select
top n-1 empsal from tblemp e)
note:- here the n will be the number of only row you would
like to display.
here in the above case n=2 i.e., n-1=1
so this will be the querry:
select top 1 * from tblemp b where b.empsal not in(select
top 1 empsal from tblemp e)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / m
IN Mysql we can do like this,
in that number starts from 0 so first parameter show
after LIMIT is row no. means here second row
and next 1 for limit that how many records do u want
to show. it means 1 record.
SELECT *
FROM `student_info`
LIMIT 1 , 1;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shince jose
select * from (
select ROW_NUMBER() OVER (ORDER BY alias) as rowid ,alias
from tbl) a where rowid=2.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajeev thakur
(select * from emp where rownum<3) minus (select * from emp
where rownum<2);
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amedela chandra sekhar
SQL> select * from (select rownum as rno,emp.* from emp)
2 where rno=&n;
Enter value for n: 2
old 2: where rno=&n
new 2: where rno=2
RNO EMPNO ENAME JOB MGR
HIREDATE SAL
---------- ---------- ---------- --------- ----------
--------- ----------
COMM DEPTNO
---------- ----------
2 7499 ALLEN SALESMAN 7698
20-FEB-81 1600
300 30
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vamsi nukala
select * from(select rownum as rno,emp.* from emp)where rno=2;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sushma s
select * from emp where rownum<=2
minus
select * from emp where rownum<2
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amit kumar (patna)
select * from
( select rownum rn, job_ticket_mst.* from job_ticket_mst where rownum<=2)
where rn=2
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / priya
select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc
Is This Answer Correct ? | 1 Yes | 1 No |
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
what is sql? : Sql dba
what is unique key constraint? : Sql dba
How would you convert date into julian date format?
What are the three pl sql block types?
What is the difference between microsoft access and sql server?
Can I create table without primary key?
What is scalar function?
How delete all records from table in sql?
What is data profiling in sql?
Why partition by is used in sql?
What is the difference between cross join and natural join?