ziemelis Posted February 3, 2010 Report Share Posted February 3, 2010 Sveiki, sekojošs kods veido topu: SELECT TOP 100 id, vards, punkti FROM table1 ORDER BY punkti DESC kā lai apskatot noteiktu ierakstu, nosaka viņa vietu topā? Quote Link to comment Share on other sites More sharing options...
bubu Posted February 3, 2010 Report Share Posted February 3, 2010 SELECT COUNT(*)+1 FROM table1 WHERE table1.punkti > $punkti Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.