Do not display Row_Number() OVER column

I have a query where I am trying to get only the first record for a field that has the same value for multiple records. I am using Row_Number OVER(), and the query is working fine but it displays the Row number column in the result set. How do I avoid displaying that row number column?


Show us the query.

I do not want row number column to be shown in the result set from this query, thanks.

WITH _table AS
a.*, ROW_NUMBER() OVER(PARTITION BY a.BondNum ORDER BY a.BondNum ) AS freq
FROM tblA a)X
WHERE freq = 1

Then change your SELECT * to only the columns that you want.

Thanks Tara, why didn't I think of it? because I do not have ability to think. Thanks for your time.