Click here to Skip to main content
14,700,123 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi there, how do I show row numbers in my data table in jsp?
syed shanu 3-Nov-14 21:44pm
chk this link hope this will help you,

1 solution


SELECT Col1, Col2, ROW_NUMBER() over (ORDER BY col1) AS Number
FROM tableName

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900