Databases
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment