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 - 2000-10-16 : 18:55:30
|
Daniele writes "Hello guys!
Very nice site.
I've a query like that
SELECT Count(ID) AS Rank, FROM Query_Rank
WHERE total> (SELECT Total FROM Query_Rank WHERE ID=myvalue)
This query was written to calculate the position of our products in the top ten selling list.
The problem is that if the books is on the top, it returns 0.
If the books has never been sold, it returns 0.
How to know if the book is real the top selling?
Thanks alot guys!" |
|
|
|
|
|
Position in a top ten selling list