T-SQL returning 1 record

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Ram Ram Ten Centuries Points: 1079 More actions · Answer 1

SEELCT ColumnA,MIN(ColumnB) OR MAX(ColumnB)

FROM tblXYZ

GROUP BY ColumnA

Ram

phamm Say Hey Kid Points: 679 More actions · Answer 2

Thanks Sriram.

What if I have several more columns after columnb? I tried your query when I have several columns after columnb and the query didn't work.

Dinakar Nethi-176633 SSCarpal Tunnel Points: 4689 More actions · Answer 3

Here's one way:

SELECT top 2 columna, columnb , DENSE_RANK() OVER (PARTITION BY columna ORDER BY columnb) AS DENSE_RANK

FROM yourTable

ORDER BY dense_rank

******************
Dinakar Nethi
Life is short. Enjoy it.
******************

Ram Ram Ten Centuries Points: 1079 More actions · Answer 4

Try this out (If you have more columns)

SELECT A.*

FROM tblXYZ AS A

INNER JOIN (

SELECT ColumnA,MIN(ColumnB) AS ColumnB

FROM tblXYZ

GROUP BY ColumnA

&nbsp AS B

ON A.ColumnA = B.ColumnA

AND A.ColumnB = B.ColumnB

Ram