Create a Random list

[jeffwest1]

In a table i have a list of names and address's, each of these has a unique client ID, and each of these clients is allocated a caseload advisor.

In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors.

I can't seem to get the random ness, i always end up with the first 10, does anyone have an idea how to do this in Sybase?

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[PDreyer]

Something like this?
select top 6 id from sysobjects order by newid()

 

[jeffwest1]

The only problem with that is that it always just gives me the same 6.

I have solved this now anyway using Crystal reports out of the database.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.