Help with Psudo Column in SQL Statement

From: <amerar_at_iwc.net>
Date: Wed, 29 Aug 2007 06:52:42 -0700
Message-ID: <1188395562.928374.173390@d55g2000hsg.googlegroups.com>

Hi All,

I have a query in which I need the first column to basically be the row number. This is not the ROWNUM psudo column, just simply a counter. The query is below. I basically need the number of the row in the result set.......

Any ideas how I can implement this into the current query???

Thanks for your help.

SELECT NULL, m.comp_name, m.ticker, NVL(sd.avg_rating,-9999), NVL(ROUND(sd.avg_rating_pr,2),-9999),

       NVL(sd.num_up_rating_1w,-9999),
NVL(sd.num_dn_rating_1w,-9999)
FROM master_table m, stock_data sd
WHERE m.m_ticker=sd.m_ticker(+) AND avg_rating IS NOT NULL AND m.m_ticker IN

   (SELECT m_ticker FROM comp_ind WHERE ind_code = UPPER('197')) ORDER BY sd.avg_rating, m.comp_name;

So:

1 ...data
2 ...data
3 ...data

etc...... Received on Wed Aug 29 2007 - 08:52:42 CDT