a counter in a select statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SQLGuy - 21 Sep 2005 06:57 GMT

How do I get a counter in a select statement output

Say if I do
Select counter, col1, col2 from table1

The output should be

Counter Col1 Col2
1 val11 val21
2 val12 val22
3 val13 val23
4 val14 val24

Reply to this Message

Karel - 21 Sep 2005 08:51 GMT

Hi guy,

This is a possibility:

select count(*) recnum, a.naam, a.voornaam
from persoon a
inner join persoon b
on a.p_persoon >= b.p_persoon
GROUP BY a.naam, a.voornaam
ORDER BY recnum

Greetz,

Karel

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...