Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zhshqzyc
Posting Yak Master
240 Posts |
 Posted - 2007-10-17 : 13:40:47
|
| 1)Which statement shows the maximum salary paid in each job category of each department?_______A. select dept_id, job_cat,max(salary) from employees where salary > max(salary);B. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat;C. select dept_id, job_cat,max(salary) from employees;D. select dept_id, job_cat,max(salary) from employees group by dept_id;E. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;2)description of the students table: sid_id number start_date date end_date datewhich two function are valid on the start_date column?_________¡£A. sum(start_date)B. avg(start_date)C. count(start_date)D. avg(start_date,end_date)E. min(start_date) F. maximum(start_date) |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-10-17 : 13:56:35
|
| Which one do you think it is? Give us your answer and reasoning and then we can verify or correct you before your professor does. Plus your prof might ask how you arrived at your answer.Jim |
 |
|
|
mastajbl
Starting Member
42 Posts |
Posted - 2007-10-17 : 14:07:38
|
| 1.) F 2.) G I wished i woulda thought of posting my questions on forums when i was in school... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 14:26:13
|
"I wished i woulda thought of posting my questions on forums when i was in school..."How would that have helped? As of now you would know nothing, no-one would employ you, prospective employers will search the internet before asking you for interview and would discover how you had faked your way through school; instead they will respect you for the hard work you put in studying and the skills you have acquired, which will be apparent from the very first interview question they ask you.And when you are in a position (maybe already) of asking people to interview you know how the modern lazy-student scams work But I don't mind helping students who are stuck. When I got stuck I used to ask a peer or a senior for help, the seniors frequently had all sorts of reasons (some good, some not-so-valid!) why they couldn't/wouldn't help, but the internet is a much wider Peer & Senior group and thus A Good Thing if not abused.Kristen |
|
|
|
|
|
|
|
|
seeking answer