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
18491 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 replication with database mirroring? : sql server database administration

985

What are the database objects? : SQL Server Architecture

984

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

940

What stored by the model?

981

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1065

Can we add a cpu to sql server?

957

Explain transaction isolation levels in sql server?

1034

What are the system database in sql server 2008?

974

Can you please explain the difference between primary keys and foreign keys?

1056

What are different types of join?

1234

How do you make a trace?

954

Can sql server be linked with other servers like oracle?

902

What are date and time data types in ms sql server?

1017

What guidelines should be followed to help minimize deadlocks?

868

What is isnull() operator?

975