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.
| Author |
Topic |
|
craigsmith
Starting Member
1 Post |
 Posted - 2002-07-10 : 17:04:30
|
| Hi there,Can anyone help?I would like to SELECT 6 RANDOM records from a table based upon year published. Basically, the application is to display random pictures on a web page based upon their year, say 1 pic from 2000, 1 pic from 2001, etc...Thanks in advanceCraig |
|
|
M.E.
Aged Yak Warrior
539 Posts |
|
|
|
|
|
select 1 random record from each year!