Home
Blogs
Forums
News
Portfolios
Projects
Tutorials
35 users logged in
New? Learn about game development.
Before posting, review our community guidelines.
Follow Us
Chat in the GameDev.net Discord!
Mastodon
Back to NeHe Productions

a sql question

Started by
3 comments, last by Pillejunior 20 years, 3 months ago
I have these 2 tables STUDYCENTRE studycentrecode studycentrename TEACHER teachercode teachername studycentrename coursecode and i want for every studycentre the studycentrecode, the number of teachers and that number is descending order. Can you people help me with the sql statement? thanx in advance
Advertisement
what have you got so far?

edit: And btw why did you post this in the nehe forum?

[edited by - Lantz on January 7, 2004 4:36:31 PM] 
SELECT StudyCentre.studycentrecode, StudyCentre.studycentrename, count(teachercode) as TeachersFROM StudyCentre INNER JOIN Teacher ON StudyCentre.studycentrename = Teacher.studycentrenameGROUP BY StudyCentre.studycentrecode, StudyCentre.studycentrenameORDER BY count(teachercode) desc
Disclaimer, I can''t remember off the top of my head of the order by comes before the group by or the other way around. Try both ways if it errors.

Also, just a note, I''d suggest using the studycentrecode as the foreign key in the Teacher table as opposed to the studycentrename (assuming the studycentrecode is the primary key).

Hope that helps,

Joel Martinez
http://www.codecube.net/
Joel Martinez
http://codecube.net
[twitter]joelmartinez[/twitter]
Which forum should i post it. I know here are a lot of clever guys.

I have
SELECT STUDYCENTRE.studycentrecode, COUNT (Teacher.Teachercode)
FROM STUDYCENTRE, TEACHER

but i know this is the wrong way
Thanx you joelmartinez

it seems to work, i am a lot furhter anyway know, thanx

This topic is closed to new replies.

Advertisement

Popular Topics

Aybe One
How do you manage yourself and your time as years pass on? GDNet Lounge
Catomax26
How can i NOT get lost and completely lose interest in the infinite sea of game development? For Beginners
ReignOnU
Do your part to stop global warming and climate change GDNet Lounge
Konjointed
C++ how do you use dependency injection? For Beginners
Jikoob
Too many managers? General and Gameplay Programming
aigan
The promise of freedom in story games Game Design and Theory
Advertisement

Recommended Tutorials

Bojanovski
Capsule Inertia Tensor Math and Physics
Myopic Rhino
Basics of GLUT Graphics and GPU Programming
Myopic Rhino
Designing an Extensible Particle System using C++ and Templates Graphics and GPU Programming
y2kiah
Game Engine Containers - handle_map General and Gameplay Programming
Myopic Rhino
Converting MS-DOS-based Games to Windows 95: A Report from the Trenches Graphics and GPU Programming

Reticulating splines

About GameDev.net
Community Guidelines
Terms of Service
Privacy Policy
Contact Us
Copyright (c) 1999-2024 GameDev.net, LLC
Back to Top