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 |
what are ddl statements in mysql? : Sql dba
Why do we use sqlite?
what is difference between decode and case function?
What are sql constraints?
Which sql statement is used to return only different values?
How do I run sql?
How do you write an index?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What are variables in pl sql?
What is form and report?
what are all the different types of indexes? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba