Get special record position in records

Get special record position in records

omid_student
Omid Aghakhani
Posts: 381
Threads: 119
Joined: May 2015
Reputation: 0

02-24-2018, 11:47 AM

Hi
I execute this query in database
SELECT * FROM tbl_user ORDER BY sScore
and result is
Username sScore
1 jack 100
2 Sara 59
3 frank 20
4 safar 10
5 omid 5
6 asghar 2

I need to know that what is grade of Sara between in all user
Also i need to know what is position of Sara in list (Sara position is 2

Messages In This Thread

Get special record position in records - by omid_student - 02-24-2018, 11:47 AM

RE: Get special record position in records - by Wouter60 - 02-24-2018, 12:21 PM

RE: Get special record position in records - by omid_student - 02-24-2018, 11:03 PM

RE: Get special record position in records - by omid_student - 02-24-2018, 11:06 PM

RE: Get special record position in records - by ivantcholakov - 02-24-2018, 05:26 PM

RE: Get special record position in records - by Wouter60 - 02-25-2018, 12:59 AM

RE: Get special record position in records - by omid_student - 02-25-2018, 02:41 AM