Do not display Row_Number OVER column in result set

Question

Post reply

Do not display Row_Number OVER column in result set

ramadesai108

SSChampion

Points: 10609
More actions
December 4, 2015 at 2:07 pm

#305931

Hello,
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?
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ramadesai108 SSChampion Points: 10609 More actions · Answer 1

ramadesai108

SSChampion

Points: 10609

December 4, 2015 at 2:38 pm

#1844169

I have resolved the issue.

Phil Parkin SSC Guru Points: 246993 More actions · Answer 2

ramadesai108 (12/4/2015)
I have resolved the issue.

It may be of interest to other forum members to know how you solved your problem. I'm guessing you did something like

With (your original query) as rws

Select cols

From rws

Or did you find another way?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

A SELECT TOP 1...ORDER BY would also do the trick.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 4

ramadesai108 (12/4/2015)
I have resolved the issue.

Cool! Please post your solution.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Ed Wagner (12/4/2015)
A SELECT TOP 1...ORDER BY would also do the trick.

Not necessarily. RowNumber can do grouping, and so return one row per partition. Top 1 is just top 1.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

GilaMonster (12/7/2015)
Ed Wagner (12/4/2015)
A SELECT TOP 1...ORDER BY would also do the trick.
Not necessarily. RowNumber can do grouping, and so return one row per partition. Top 1 is just top 1.

Touche.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions