|
[VIEWED 9856
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
chinday
Please log in to subscribe to chinday's postings.
Posted on 02-12-19 6:41
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
Can you please help me get sql query for below output from the input provided :
TABLE:
| No of
classes |
Student |
| Science |
A |
| Commerce |
A |
| Science |
B |
| Science |
C |
| Commerce |
C |
| Commerce |
C |
| Science |
B |
| Science |
A |
| Science |
G |
| Commerce |
D |
| Commerce |
D |
OUTPUT:
| No of
classes |
Student |
Count |
| Science |
A |
2 |
| Commerce |
A |
1 |
| Science |
B |
2 |
| Science |
C |
1 |
| Commerce |
C |
2 |
| Commerce |
D |
2 |
| Science |
G |
1 |
I will appreciate the help.
|
| |
|
|
|
|
nepalinaike
Please log in to subscribe to nepalinaike's postings.
Posted on 02-12-19 6:50
PM [Snapshot: 13]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
You might want to try something like this: select number of classes, student, count(*) as Count From tablename group by number of classes, student Good luck!
|
| |
|
|
Lee_St
Please log in to subscribe to Lee_St's postings.
Posted on 02-12-19 9:54
PM [Snapshot: 119]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
SELECT NO OF CLASSES,STUDENT,COUNT(*) AS COUNT FROM TABLE GROUP BY NO OF CLASSES,STUDENT ORDER BY STUDENT ASC;
|
| |
|
|
STUPIDA
Please log in to subscribe to STUPIDA's postings.
Posted on 02-13-19 1:42
AM [Snapshot: 157]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
SELECT [No of classes], Student, COUNT(*) AS Count FROM TABLE GROUP BY [No of classes], Student ORDER BY Student ASC, [No of classes] DESC;
|
| |
|
|
