calculate score in ms sql

[codekhan]

Hi,



Suppose I have a table with 5 rows (t1 - t5) and 6 columns (c1 - c6) and I run a select query on it using the where clause.. (specifying value of c1) and in the result I get two rows say T1 and T4 ,,now I want to rank my results based on the other unknown columns..

Is there any way to calculate the rank (score) of the resultant rows?

[ck9663]

Hi,



Suppose I have a table with 5 rows (t1 - t5) and 6 columns (c1 - c6) and I run a select query on it using the where clause.. (specifying value of c1) and in the result I get two rows say T1 and T4 ,,now I want to rank my results based on the other unknown columns..

Is there any way to calculate the rank (score) of the resultant rows?

if you could post some sample mock data, of your table and what you want to accomplish, it would be much easier..

-- CK

[Brad Orders]

I'm not sure, but is this the kind of thing you are after?

SELECT C1
FROM TableName
WHERE C1 = @SomeParameter
ORDER BY C2, C3, C4
 

If you want to order the results by a column in descending order, just put DESC after the column name (eg. "C2 DESC")

HTH.

[amitpatel66]

Hi,



Suppose I have a table with 5 rows (t1 - t5) and 6 columns (c1 - c6) and I run a select query on it using the where clause.. (specifying value of c1) and in the result I get two rows say T1 and T4 ,,now I want to rank my results based on the other unknown columns..

Is there any way to calculate the rank (score) of the resultant rows?

Could you please be more specific or your requirement. A sample data with a sample output required will help the experts to better understand your requirement.