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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-16 : 08:47:41
|
| Tokson writes "how can i solve this Query - select 10 as M1, 20 as M2, M1+M2 as Total " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-09-16 : 08:48:54
|
| SELECT 10 AS M1, 20 AS M2, 10+20 AS TotalYou can also use a subquery:SELECT M1, M2, M1+M2 FROM (SELECT 10 AS M1, 20 AS M2) A |
 |
|
|
|
|
|
need help