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 - 2001-10-30 : 08:37:47
|
sanjeev writes "Hi,I have following table :select column_name1,vals from Tab1-----------------------------------column_name1 vals------------------------------------------------- -------1000.0 8.01001.0 9.01002.0 4.01002.0 5.01000.0 8.0--------------------------------------------------------------I need following result :column_name1 products------------- -------1000.0 64.0 (8.0*8.0)1001.0 9.0 (9.0) 1002.0 20.0 (4.0*5.0) ------------------------------------------------------------How to do this ?sanjeev ....kathmandu-34,Nepal" |
|
|
|
|
|
about sql product