Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to retrive only second row from table?

Answers were Sorted based on User's Feedback



how to retrive only second row from table?..

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

how to retrive only second row from table?..

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

how to retrive only second row from table?..

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

how to retrive only second row from table?..

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

how to retrive only second row from table?..

Answer / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Is This Answer Correct ?    1 Yes 0 No

how to retrive only second row from table?..

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

how to retrive only second row from table?..

Answer / vamsi nukala

select * from(select rownum as rno,emp.* from emp)where rno=2;

Is This Answer Correct ?    1 Yes 0 No

how to retrive only second row from table?..

Answer / sushma s

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

Is This Answer Correct ?    1 Yes 0 No

how to retrive only second row from table?..

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

how to retrive only second row from table?..

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

Post New Answer



More SQL PLSQL Interview Questions

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  


How does rowid help in running a query faster?

0 Answers  


how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  


Why we use join in sql?

0 Answers  


Can we write dml inside a function in sql server?

0 Answers  






What happens when a trigger is associated to a view?

0 Answers  


What does rownum mean in sql?

0 Answers  


What is embedded sql what are its advantages?

0 Answers  


What packages(if any) has oracle provided for use by developers?

1 Answers  


What is a pragma statement?

0 Answers  


What is difference sql and mysql?

0 Answers  


Explain how exception handling is done in advance pl/sql?

0 Answers  






Categories