SQL query Help!

Posts 4 · Viewed 6865 · Go to Last Post

chinday

· Snapshot 0

Like · Likedby · 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

· Snapshot 13

Like · Liked by · 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

· Snapshot 119

Like · Liked by · 0

SELECT NO OF CLASSES,STUDENT,COUNT(*) AS COUNT
FROM TABLE
GROUP BY NO OF CLASSES,STUDENT
ORDER BY STUDENT ASC;

STUPIDA

· Snapshot 157

Like · Liked by · 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;

Please log in to reply to this post

You can also log in using your Facebook

View in Desktop

What people are reading

Visitor from US is reading SQL query Help!

Visitor from DE is reading बुद्ध के साँच्चै तिमी मेरो देशमा जन्मेका थियौ?

Visitor from US is reading Do I need a strong reason for Advance Parole

Visitor from US is reading Happy Birthday Mokshya

Visitor is reading Nepali in Tri-Cities, WA

Visitor is reading US Immigration Blog

Visitor from DE is reading ......पन्छिन चाहन्छु म

Visitor from US is reading Changba Dance

Visitor from US is reading Score Update Nepal Vs Malaysia

You might like these other discussions...

logan » independent

ट्रंपको लागि सति जान खोजेको हो वा प्रतिरोध ?

· Posts 2 · Viewed 135

logan

गर्भनिरोध मानब जाति देखि पशु पंक्षीलाइ पनि चाहिने भो

· Posts 1 · Viewed 80

Sajha Classifieds

Classifieds Summary:

· Posts 1 · Viewed 86

suggestions » ShreeRaam

documents for tourist visa

· Posts 5 · Viewed 1139

NepalNews Sajha

News Summary from Nepal for Friday, April 19, 2024

· Posts 1 · Viewed 83

IamDJ » Meronepal 1

TPS Re-registration case still pending ..

· Posts 65 · Viewed 12270 · Likes 12

Sajha Classifieds

Classifieds Summary: Jobs in VA, Room/Apt in MA

· Posts 1 · Viewed 158

NepalNews Sajha

News Summary from Nepal for Thursday, April 18, 2024

· Posts 1 · Viewed 167

Sajha Classifieds

Classifieds Summary: Jobs in VA, Room/Apt in MA,VA

· Posts 1 · Viewed 236

NepalNews Sajha

News Summary from Nepal for Wednesday, April 17, 2024

· Posts 1 · Viewed 243