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 |
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
Is sql scripting language?
What is normalisation and its types?
What is a native sql query?
What is sql exception?
what is a relationship and what are they? : Sql dba
What do you mean by rowid?
Is subquery faster than join?
What is pivot table in sql?
Can you do multiple joins in sql?
Can we join tables without foreign key?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)