- This topic has 0 replies, 1 voice, and was last updated 10 years, 4 months ago by .
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.
Tagged: brudekjoler_La oss #tbt å Kaley Cuoco bryllup og bilde Du Tapte: Hennes Perfect Pink Floral Veil
You have a fantastic SELECT statement.
Now you need to add a new column with simple row count: 1, 2, 3 . . .
Here is how you can do it on DB2 platform:
SELECT ROW_NUMBER() OVER (), VLEDUS, VLEDBT, count(*) FROM
F06116Z1 GROUP BY VLEDUS, VLEDBT
The result will look similar to this:
ROW_NUMBER User Batch COUNT ( * )
ID Number
--------------- ---------------
1 U11 00170835 170
2 U222 00170861 54
3 U33 00170865 41
4 U44 00170866 11
5 U55 00170863 9
Please. let me know, if this syntax works on different platforms.
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor