Hello all.
I have a small problem with sql.
I have a table that has name and rank.
For example the ranks would be getted like :
select name,score from scores order by score desc
So the first line i would see would be person with rank 1, second line with rank 2...
But how can i know in what line does the name appears ?
For example i want to know rank of the person named 'abc'.
Thanks in advance.
jen140
0
Junior Poster
Recommended Answers
Jump to Postselect name,score from scores where name = 'jen140'
Jump to PostDon't understand what you are trying to achieve.
All 5 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
jen140
0
Junior Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
almostbob
866
Retired: passive income ROCKS
jen140
0
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.