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
18932 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 scd (slowly changing dimension)? : sql server analysis services, ssas

989

Explain primary key, foreign key and unique key?

969

Explain what are the authentication modes in sql server?

990

What do you mean by acid?

973

What is best institute to Learn DotNET And SQL in chennai?

2149

What are the different types of sub-queries?

1026

What are the different types of Indexes available in SQL Server?

980

Define master database?

1039

How can I know what locks are running on which resource?

934

Explain Reporting Life Cycle?

123

how many layers of tcp/ip protocol combined of? : Sql server database administration

980

What are subqueries in sql server?

1095

How do I debug a stored procedure in sql server?

1078

Explain Capacity planning to create a database? and how to monitor it?

4176

How to delete duplicate rows in sql server?

1082