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 |
|
NarayanaMoorthy
Starting Member
19 Posts |
 Posted - 2007-08-25 : 01:22:19
|
| Hai,I have a table named "Student" which contains four columns and three rows.I want to see just the first row only from the "Student" table and the marks should calculated for the rows.Here is my tablesno smark1 smark2 smark31 50 50 502 60 60 603 70 70 70The Output should be:sno smarks(smark1+smark2+smark3)1 1502 1803 210Narayana Moorthy |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-25 : 01:25:20
|
| Create view my_view asSelect sno,(smark1+smark2+smark3) as smarks from yourtableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
"Views"(edited)