How can I select records randomly from MS SQL Server Table?

Reply

Join Date: May 2006
Posts: 1
Reputation: jas2k is an unknown quantity at this point 
Solved Threads: 0
jas2k jas2k is offline Offline
Newbie Poster

How can I select records randomly from MS SQL Server Table?

 
0
  #1
May 16th, 2006
I have a table in MS SQL Server 7.0 Like this:

Id Cat_Name Definition Image
101 A1 --------------- *************
102 B1 ----------- *************
101 A2 ------------------ *************
103 C1 ----------------- *************
101 A3 --------------- *************
101 A4 ------------------ *************
102 B2 -------------------- *************
101 A5 -------------- *************
101 A6 ----------------- *************


From above table, How can I select 3 – 5 records where iId is 101. Means result should be:
<<101>><<A3>>----------------<<***********>>
<<101>><<A4>>----------------<<***********>>
<<101>><<A5>>----------------<<***********>>
Reply With Quote Quick reply to this message  
Join Date: Jul 2005
Posts: 483
Reputation: campkev is an unknown quantity at this point 
Solved Threads: 19
campkev campkev is offline Offline
Posting Pro in Training

Re: How can I select records randomly from MS SQL Server Table?

 
0
  #2
May 16th, 2006
might be able to help you with this but need a few questions answered.
1) I am assuming that ID+Cat_Name is unique, in other words, there cannot be two 101 A1 entries. is this correct?
2) what are specifications for the Cat_Name field? Is it always exactly two characters(one letter and then one number) or can it be one letter followed by any integer, etc.
3) you said 3-5 rows returned. Do you want that number random as well, or can it be the same number of rows returned everytime as long as that number is between 3-5?
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC