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 |
|
kss80kss
Starting Member
3 Posts |
 Posted - 2005-05-13 : 05:17:22
|
| hi friends,IS-0209 John Hagan Senior Programmer 32 4 120000IS-0206 Ganesh Pillai Senior Programmer 32 4 110000IS-0201 Anamika Pandit Web Designer 27 3 90000IS-0212 Mary Anchor Web Designer 26 2 85000IS-0205 Fred Kruger Programmer 35 3 75000IS-0204 Edward Sakamuro Programmer 25 2 75000IS-0200 Alok Nanda Programmer 32 3 130000IS-0208 Hassan Rajabi Multimedia 33 3 90000IS-0202 Arthur Hoopla Multimedia 32 1 75000IS-0211 Kim Hunter Web Designer 32 2 110000IS-0216 Roger Lewis Senior Programmer 35 2 100000IS-0203 Danny Gibson Senior Programmer 30 1 90000IS-0213 Monica Sehgal Marketing 30 3 90000IS-0207 Hal Simlai Marketing 27 2 70000IS-0210 Joseph Irvine Marketing 27 2 72000IS-0217 Shahida AAli Programmer 32 3 70000IS-0215 Peter Champion Marketing 36 4 120000I'm having an employ table and trying scenario like this,select avg(salary) from employ group by title where title in ('programmer','Webdesigner').Result of this queries is some like 13000 and 30000. Now I want to sum these two resultant value.Colud you please tell me how to proceed in this case. I'm new to SQL.ThanksSaravanan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-13 : 05:54:58
|
| Saravanan, Try thisselect sum(sal) from (select avg(salary) as sal from employ group by title where title in ('programmer','Webdesigner') TMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Queries