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-22 : 05:50:14
|
| 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 not be calculated.Here is my tablesno smark1 smark2 smark31 70 80 602 50 70 90 3 60 80 70 Narayana Moorthy |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-08-22 : 06:17:14
|
| select top 1 sno, smark1, smark2 ,smark3from studentwhat do you mean "the marks should not be calculated?Jim |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-22 : 06:34:10
|
quote:
Originally posted by NarayanaMoorthy
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 not be calculated.Here is my tablesno smark1 smark2 smark31 70 80 602 50 70 90 3 60 80 70 Narayana Moorthy
Post your expected resultMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
"Views"