Take a example as to find the same student who got first and second marks

if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..

1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..

Question Posted / hitesh kumar vyas s

17 Answers
18653 Views
3i Infotech, Rolta, TCS, I also Faced
E-Mail Answers

Answer Posted / hitesh kumar vyas s

Take a example as to find the same student who got first and
second marks in each of sub.

SELECT RollNo,COUNT(Rank) FROM Student GROUP BY RollNo,rank
ORDER BY rank

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between NOROW and LOCKROW?

2789

How to change the name of a database user?

923

What is sql azure database?

206

What happens if ntwdblib.dll is missing on your machine?

1117

Can coalesce return null?

958

What are the different types of lock modes in sql server 2000?

894

What are filegroups in sql server?

1025

how to determine the service pack currently installed on sql server? : Sql server database administration

928

Can foreign key be deleted?

882

How to delete duplicate rows?

946

What is ms sql server reporting services?

1006

Why use view instead of a table?

896

What are commonly used mssql functions in php?

1020

How to integrate the ssrs reports in application?

949

What is self contained multi valued query?

958