Random with Distinct rows - SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Random with Distinct rows - SQL Server

Author

Topic

k80sg
Starting Member

7 Posts

Posted - 2013-05-31 : 14:51:04

Hi, I need to display random with distinct records

eg.

65 Pencil
66 Pencil
68 Eraser
69 Pen

Output:

66 Pencil
68 Eraser
69 Pen

Or

65 Pencil
68 Eraser
69 Pen

Can someone please kindly assist. Thanks.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-05-31 : 17:20:13

One of these?

SELECT MAX(NumberColumn),PencilColumn FROM Tbl
GROUP BY PencilColumn;

;WITH cte AS
(
	SELECT *,ROW_NUMBER() OVER (PARTITION BY PencilColumn ORDER BY  NEWID()) AS OrderingId FROM Tbl
)
SELECT NumberColumn, PencilColumn FROM cte WHERE OrderingId = 1;

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources