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
19163 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 are “lost updates”?

1001

what are user defined datatypes? : Sql server database administration

966

How do I uninstall sql server 2014?

936

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

Which is the main third-party tool used in sql server?

942

How to write a query with a full outer join in ms sql server?

1081

What is query optimizer in sql server?

1024

What is a join in sql?

1093

Does partitioning help performance?

937

How to insert new line characters into strings?

991

Explain transaction server consistency?

976

What is the process of normalization?

1126

List all the types of user-defined functions?

1102

What is compound operators?

1059

What are a scheduled jobs?

956