Basic SQL Programming Question - Joining 3 tables then sorting

Question

Post reply

Basic SQL Programming Question - Joining 3 tables then sorting

Viewing 10 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Dabears2k SSC Enthusiast Points: 143 More actions · Answer 1

Dabears2k

SSC Enthusiast

Points: 143

June 17, 2009 at 9:22 am

#1011056

bump for help.

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

could you supply some the definition of your table and some sample data with the expect output.

It's pretty hard to write a query for a desired output if you dont' know what data you working with.

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Steve Jones - SSC Editor SSC Guru Points: 738043 More actions · Answer 3

You'll also need a column in your query for the table or something else to group by.

For your results, not sure what the values mean.

Dabears2k SSC Enthusiast Points: 143 More actions · Answer 4

Dabears2k

SSC Enthusiast

Points: 143

June 17, 2009 at 9:55 am

#1011091

Chris hit it perfectly.

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 5

try this:

SELECT

Category,

COUNT(*)

FROM

(SELECT

CASE WHEN salary between 0 and 10000 then 'range = 20000 and salary = 30000 and salary = 40000 and salary = 50000 and salary = 60000 and salary = 70000 and salary = 80000 and salary = 90000 and salary = 100000 and salary < 110000 then 'range $100k-$110k'

ELSE 'OTHER'

END as Category

FROM employee) n

GROUP BY Category

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Dabears2k SSC Enthusiast Points: 143 More actions · Answer 6

Dabears2k

SSC Enthusiast

Points: 143

June 17, 2009 at 10:10 am

#1011105

perfection!!!

Thanks

ps. One Orange Chip Points: 29423 More actions · Answer 7

Dabears2k, Also go through the first link in Christopher's signature. This will help you to get correct answer to the point in future :-). You posted desired output much later than it should have been. i concentrated more on the syntax than the output:hehe:.

Pradeep Singh