Different ways to write Distinct Query - MSSQL

Question

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

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

MonkeyK Old Hand Points: 388 More actions · Answer 1

How about this?

select col1, col2 from table1

except

select null, null

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 2

SSCrazy Eights

Points: 9708

November 3, 2011 at 1:05 am

Nice one. Thanks for sharing

Thanks

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

May 12, 2016 at 6:30 am

Thanks for the script.