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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-12 : 07:49:17
|
| Priti writes "Hi,I m doing slideshow application. for that I m using Ms Sql 7.0 server.Now I want to retrieve each time 10 different records order by date (it is the column) from table out of 100 records. Plz, help me for writing the sql query for this." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-12 : 07:52:01
|
| [code]Select top 10 * from Tableorder by NewID(), [Date][/code]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
How to retrieve random data from Ms Sql database