SQL query Help!

Posts 4 · Viewed 6907 · 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 US is reading if i unlock tmobile phone for nepal use, will it work here b

Visitor from FR is reading Mata Tirtha Aushi(NamasteService Pvt. Ltd)

Visitor from RU is reading AAFAILAI BIRSEACHU...................

Visitor from RU is reading What a thriller movie "Department (2012)

Visitor from US is reading ~~ चौतारी - शतकांक विशेष ~~

Visitor from US is reading plane crash near TIA airport

Visitor from RU is reading This is what the Maoists' had to say!!! : Miss Nepal Diaries

Visitor from FR is reading Any Suggestion is highly appreciated..

You might like these other discussions...

wakeyour_mind

These Student Protests Against Israel Are the Most Important Political Movement of Our Lifetime

· Posts 1 · Viewed 87

Lucky_Nepali » nash24

TPS advance parole Travel document i-131, Class of Admission ?

· Posts 2 · Viewed 266

Smriti-malla

मरेर गएनि कहिल्यै नमर्ने मान्छे!

· Posts 1 · Viewed 169

bandedv2023 » pitambar

ढ्याउ गर्दा दसैँको खसी गनाउच

· Posts 24 · Viewed 7447 · Likes 2

sm01234 » Logan

emergency donation needed

· Posts 26 · Viewed 2284 · Likes 5

Sajha Classifieds

Classifieds Summary: Room/Apt in MA

· Posts 1 · Viewed 84

NepalNews Sajha

News Summary from Nepal for Thursday, April 25, 2024

· Posts 1 · Viewed 105

forthecloset

10 Most popular sex toys hiding places

· Posts 1 · Viewed 190

sojho_bahun » chicagoan

Is this a progressive step?

· Posts 2 · Viewed 293

crazy_love » crazy_love

मन भित्र को पत्रै पत्र!

· Posts 13 · Viewed 3455 · Likes 6