 |  |  |  |  |  |  |  |
Assign Record Numbers to Records
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
In a application for online test, the rank list is computed as follows-
How can we make sure that the first record gets rank1, second rank2 and so on... I want to add the field to the table.
Can this be done using a single pass? As in,a workaround is to create a temp table using the query and then process each record using a script to assign the rank. Is it possible without the script?
MySQL Syntax (Toggle Plain Text)
How can we make sure that the first record gets rank1, second rank2 and so on... I want to add the field to the table.
Can this be done using a single pass? As in,a workaround is to create a temp table using the query and then process each record using a script to assign the rank. Is it possible without the script?
Last edited by tuse; Apr 30th, 2009 at 10:28 am.
My blog on .NET- http://dotnet.tekyt.info
|
Similar Threads
- How can I list all the contestants? (Pascal and Delphi)
- Pascal calculator program (Pascal and Delphi)
Other Threads in the MySQL Forum
- Previous Thread: Create a Form Calculator in MySQL
- Next Thread: Transferring a db from one server to another server.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
