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 |
|
pravingate07
Starting Member
1 Post |
 Posted - 2011-09-12 : 01:34:28
|
| Hi I m new to sql , I have 2 queries?1. How to update 2 row in 3rd column?2. How to find out avg salary from two tablesIf anybody knows, plz tell me.Thanks&Regards,Pravin pravingate |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2011-09-12 : 01:35:46
|
| can you please provide some sample data.iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-12 : 01:44:22
|
| 1. normal set based update will work for you. if you want more specific answer, post some sample data to illustrate your scenario2. use AVG() function after joining tables on common fields and applying GROUP BY------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to solve these queries?