sri_mf
Active User
Joined: 31 Aug 2006
Posts: 218
Location: India
|
|
|
|
| chinthalavijaykumar wrote: |
| give me the querry for selecting 100 lines from a table |
If you want to select particular number of records use
"FETCH FIRST 4 ROWS ONLY"
Ex:
SELECT MIN(SALARY)
FROM (SELECT SALARY
FROM TABLE
ORDER BY SALARY
FETCH FIRST 4 ROWS ONLY)
WITH UR |
|
