This week's book giveaway is in the Java in General forum. We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line! See this thread for details.
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
posted 9 years ago
Hi, 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