Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: Sep 09, 2002
Aug 17, 2006 03:05:00
I am new to db2, I have a certain requirement where i have to select top 10 values from a table. please help me how it can be acheived. if any body knows a good book on db2 online then pls share the link with me
Joined: Mar 06, 2002
Aug 17, 2006 05:49:00
For fetching the top 10 values you can use the same normal sql query and simply append the following at the end of your query
FETCH FIRST 10 ROWS ONLY
ie select column_name from table FETCH FIRST 10 ROWS ONLY
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
subject: SQL question
Migrate Repository configuration
WAS and DB2 connectivity details
WAS 3.5 -> DB2 7.1 or 6.1, IBM JDK 1.2.2 or 1.3
Difference between DB2 and SQL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013