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 the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How does rowid help in running a query faster?
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.
Why we use join in sql?
Can we write dml inside a function in sql server?
What happens when a trigger is associated to a view?
What does rownum mean in sql?
What is embedded sql what are its advantages?
What packages(if any) has oracle provided for use by developers?
What is a pragma statement?
What is difference sql and mysql?
Explain how exception handling is done in advance pl/sql?