Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

SQLplus

Name: How to count 0 2008-10-29 19:53

I'm trying to count the number of 'classes' each student is taking, but I'm supposed to report back 0 if there are none. Right now, it just doesn't respond with the student.
Anyone out there been through a database class who solved this?

Name: How to count 0 2008-10-29 22:11

We're so lazy....
I got it though. Thanks for the support.
Especially the first reply, I found much inspiration from him.

It involved with the normal count as the first query(as a view)
Then another that had 0 for the select of null(as a view)
Then a union of them both.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List