Calculating Positions Query Required...........
AA Guyz i want to calculate class position of students from a table.
Sample data is as follows...
Roll # - Name - Marks
1 - ABC - 60
2 - DEF - 60
3 - GHI - 57
4 - JKL - 55
5 -MNO - 50
6 -PQR - 53
The query should return the following result.
Roll # - Name - Marks - POSITION
1 - ABC - 60 - 1
2 - DEF - 60 - 1
3 - GHI - 57 - 3
4 - JKL - 55 - 4
5 -MNO - 50 - 5
6 -PQR - 53 - 6
I want query in MS SQL Server 2000
.
Relevant Pages
- Re: Calculating Positions Query Required...........
... Sample data is as follows... ... Roll # - Name - Marks ... The query should return the following result. ...
(comp.databases.ms-sqlserver) - Re: YES/NO calculations
... vacuuming, dusting and dishes but only did the dishes= 1 out of a possible 3, ... The check marks are to be tallied up on the form. ... do I need to do a query and then insert the query info ... This will return the total sum of all 3 check fields for ALL records. ...
(microsoft.public.access.forms) - Re: UDF and SQL2000 - Why doesnt this work?
... Basically This is what I want to do - I have created a query ... as DDL (i.e. CREATE TABLE statements; ... Sample data that illustrates the problem, ... Expected output from the sample data supplied; ...
(microsoft.public.sqlserver.programming) - Re: YES/NO calculations
... vacuuming, dusting and dishes but only did the dishes= 1 out of a possible 3, ... The check marks are to be tallied up on the form. ... do I need to do a query and then insert the query info ... This will return the total sum of all 3 check fields for ALL records. ...
(microsoft.public.access.forms) - Re: YES/NO calculations
... vacuuming, dusting and dishes but only did the dishes= 1 out of a possible 3, ... The check marks are to be tallied up on the form. ... do I need to do a query and then insert the query info ... This will return the total sum of all 3 check fields for ALL records. ...
(microsoft.public.access.forms) |
|
