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 is type and rowtype in pl sql?
Explain the purpose of %type and %rowtype data types?
What is trigger and stored procedure in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
give the syntax of grant and revoke commands? : Sql dba
What is a pdo connection?
Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN
Define sql delete statement.
What is the use of non clustered index?
What is equi join in sql?
how can we find the select statement is indexed or not?
How pl/sql source code can be protected?