General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Dear Experts
Table1 has following two fields
code -----n(4)
amount----n(2)
The data in both fields is as under
code-------amount
1-------------
1401--------50
1602--------80
2-------------
2202--------40
2808--------10
Now I want to get the sum of 4 digit codes in 1 digit as
1------------130
1401--------50
1602--------80
2-------------50
2202--------40
2808--------10
Explanation
The sum of all digits that are starts with 1 with wll be written in 1 as
The sum of 1401 and 1602 will be written against 1 as 130
1-----------130
1401--------50
1602--------80
Please help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only