Home > IT Answers > Development > using group by by joining 2 tables SQL
Lak
5 pts.
 using group by by joining 2 tables SQL
SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo
there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

Software/Hardware used:
ASKED: March 25, 2010  2:36 PM
UPDATED: March 26, 2010  5:44 PM
RELATED QUESTIONS
Answer Wiki:
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you in the right direction.
Last Wiki Answer Submitted:  May 14, 2013  8:39 pm  by  Chris Leonard   2,620 pts.
All Answer Wiki Contributors:  Chris Leonard   2,620 pts. , carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Quick tutorial with exercises:
http://www.sql-ex.ru/help/

msi77
 1,610 pts.