Home » SQL & PL/SQL » SQL & PL/SQL » How to group multiple columns?
How to group multiple columns? [message #10247] Sat, 10 January 2004 20:13 Go to next message
Sudhakar
Messages: 34
Registered: May 2002
Member
A table contains three columns say Student name, subject1 grade, subject2 grade and subject3 grade. Let the grades be A,B and C. My doubt is, how to query the table to find the number of students got A,B,C grades in the 3 subjects?

Report message to a moderator

Re: How to group multiple columns? [message #10258 is a reply to message #10247] Sun, 11 January 2004 20:46 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
 
Select count(student_name) cnt
     , subject1_grade Grade
  From your_table
 Where subject1_grade = subject2_grade
   And subject1_grade = subject3_grade
 Group by subject1_grade;
Something like this?

MHE

Report message to a moderator

Previous Topic: Help with procedure
Next Topic: ROWID
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:58:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.