|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
#1
July 12th, 2006, 12:43 PM
|
|||
|
|||
|
SQL help! percent rows returned
hi i was wondering if there is an equivelent of the 'top' function as sql server. i wish to return the 'top 10 percent' rows. i cant seem to find the function!
 anuy ideas? thanks in advance! --atko
|
|
#2
July 13th, 2006, 09:24 PM
|
|||
|
|||
|
Not sure what "percent" u r asking
try this if you are looking for: select * from tablename fetch N rows only;
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > SQL help! percent rows returned |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
