M
Milton sharman
I want to order in rank order sutdent scores from a table
with fields id, score, percent position.
I read and printed a similar query on friday(21st)but
cannot find it on the site.
It contained the etery using Select
SELECT test.colour,test1.amount,(SELECT Count(*)FROM Test1
AS VT WHERE VT.Amount>=Test1.Amount)AS Stack FROM Test1;
I can follow most of this except for the VT
Also where would I enter this in a query field?
with fields id, score, percent position.
I read and printed a similar query on friday(21st)but
cannot find it on the site.
It contained the etery using Select
SELECT test.colour,test1.amount,(SELECT Count(*)FROM Test1
AS VT WHERE VT.Amount>=Test1.Amount)AS Stack FROM Test1;
I can follow most of this except for the VT
Also where would I enter this in a query field?