Easy query I can't do? Can you help?

#1

If I have a table as such..

Name Age
--------------
Eric 1
Sarah 2
Jeff 1
Ted 4
Mary 1
Sam 3

How can I do a single sql query that displays the following

Age 1 Age 2 Age 3 Age 4
3 1 1 1

TIA

#2

"asdf" <scottphelps (AT) noemailplease (DOT) com> wrote

Quote:

If I have a table as such..

Name Age
--------------
Eric 1
Sarah 2
Jeff 1
Ted 4
Mary 1
Sam 3

How can I do a single sql query that displays the following

Age 1 Age 2 Age 3 Age 4
3 1 1 1

TIA

select

(select count(*) from age where age=1) age_1,
(select count(*) from age where age=2) age_2,
(select count(*) from age where age=3) age_3,
(select count(*) from age where age=4) age_4 from dual;

#3

"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
message news:V-OdnUJtbpwDR27eRVn-pw (AT) comcast (DOT) com...

Quote:

"asdf" <scottphelps (AT) noemailplease (DOT) com> wrote in message
news:6EKIf.33213$H71.32701 (AT) newssvr13 (DOT) news.prodigy.com...
If I have a table as such..

Name Age
--------------
Eric 1
Sarah 2
Jeff 1
Ted 4
Mary 1
Sam 3

How can I do a single sql query that displays the following

Age 1 Age 2 Age 3 Age 4
3 1 1 1

TIA

select
(select count(*) from age where age=1) age_1,
(select count(*) from age where age=2) age_2,
(select count(*) from age where age=3) age_3,
(select count(*) from age where age=4) age_4 from dual;

Intresting thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Easy query I can't do? Can you help?

comp.database.oracle comp.database.oracle

Easy query I can't do? Can you help? - 02-15-2006 , 12:44 PM

Re: Easy query I can't do? Can you help? - 02-15-2006 , 07:48 PM

Re: Easy query I can't do? Can you help? - 02-16-2006 , 01:38 PM