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 - 2002-04-30 : 09:27:33
|
| prasad writes "Hello Sir, we have developed a Inventory & stores management System with oracle 8i database. in that we need to select 10 items randomly for stocks verification day-wise. In our main stores we have nearly 11,000 items. from that we need to select randomly 10 item. What is the SQL Query for achieving that ?What is the solution ?" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-30 : 09:59:55
|
| Check out the FAQ's on this site for returning random records. There's been loads of forum posts on this issue also. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-30 : 12:50:35
|
Of course, the articles and forum posts on this site will work best for you after you convert your Oracle 8i database to SQL Server 2000.  |
|
|
|
|
|
|
SQL Statement on Random Selection of Records