how to retrive only second row from table?
Answers were Sorted based on User's Feedback
Answer / saswati
select a.*
from(select e.*,rownum sl_no
from emp e) a
where a.sl_no = 2
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anusha
select * from ars_mst_user where rownum<5
minus
select * from ars_mst_user where rownum<=3;
this query for retrive fourth row
same we can retrive any row
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudip chatterjee
If the table is salary.then
SELECT * FROM salary ORDER BY income DESC LIMIT 1, 1;
here income is one attribute of salary table......
just use it.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / thanjairajan@gmail.com
select * from emp a where 2=(select count(distinct(b.rowid)) from emp b where a.rowid>=b.rowid;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / yogendra
select top 1 * from (select top 3 * from
cmdview_expertmaster order by expid) q order by expid desc
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / nilesh
hi all,
This will also work fine, try it
select top 1 * from (select top 2 * from table_name)as set
order by set.col_name desc
here table_name is the name of the table from which
you want to retrive the record.
And col_name is the column name by which you are sorting
the records
If it found wrong plz correct it....
and show it on this site
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / naresh
select * from emp e where 2=(select count(*) from emp where
sal>=e.sal);
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / ayan
SELECT * FROM employees a
WHERE 2 = (SELECT COUNT(rowid)
FROM employees b
WHERE a.rowid >= b.rowid);
this will select the 2nd row.. if we write instead of 2 it
will select 8th row.... login to hr/hr schema and run the
code. it will work fine..
Is This Answer Correct ? | 3 Yes | 7 No |
Answer / ehtesham malik
select * from emp
where rowid = (select min(rowid) from emp
where rowid not in (select min(rowid)
from emp)
)
Is This Answer Correct ? | 4 Yes | 9 No |
Answer / sagar
SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);
Is This Answer Correct ? | 14 Yes | 33 No |
What is %rowtype in pl sql?
Can there be 2 primary keys in a table?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
How to rename a table?
How do temporal tables work?
When is the explicit cursor used ?
suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?
What is the difference between the sql*loader and import utilities? : aql loader
How do you change a value in sql?
How many types of cursors are available in pl/sql?
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)