Databases
Pages
Home
MySql
Oracle
PostGRESql
MSAccess
DB2
SQL
Monday, 17 September 2012
How to retrieve record number 70 from a table of 100 records?
(select * from emp
minus
select * from emp where rownum < 70)
intersect
select * from emp where rownum <=70;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment