Counting table rows

[dbykel]

How do I count the number of rows in a table where a specific value sits that I query for?

example:

SELECT score from table WHERE score > 100 ORDER BY score desc

let's say the result is:

row1- Bob- 145
row2- Sally- 135
row3- John- 125
row4- Cindy- 115
row5- Bill- 105

What query will result in the following statement:

"Cindy has beaten 3 players with a score of 115"

Thanks

[Piranha]

select count(*)

[Sxooter]

dbykel wrote:

How do I count the number of rows in a table where a specific value sits that I query for?

example:

SELECT score from table WHERE score > 100 ORDER BY score desc

let's say the result is:

row1- Bob- 145
row2- Sally- 135
row3- John- 125
row4- Cindy- 115
row5- Bill- 105

What query will result in the following statement:

"Cindy has beaten 3 players with a score of 115"

Wait, do you only want to know about cindy?

select score from table where name='Cindy'

gets us cindy's score.

select count(*) from table where score > (select score from table where name='Cindy')

gets us the number of records where the score is greater than Cindy's