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-06-04 : 00:53:53
|
Aser writes "How to get Max and Min value for a row?
For eg. I have 10 fields for subjects. And columnwise I have students.
RollNo Englsih Maths Science History ....etc
1001 56 89 45 76
1002 54 64 90 88
The table is thus of marks of students in the 10 subjects.
Maximum marks for RollNo 1001 is 89 and Minimum is 45
Maximum marks for RollNo 1002 is 90 and Minimum is 54
Firing a SQL query I would like to know the Maximum (hightest marks obtained in all subjects) and Minimum marks(lowest marks obtained in all subjects) scored by each student.
Aser" |
|
|
|
|
|
Max and Min for Row