How can we compare two columns value in same table in MS Sql Server
We have one table ExamScore
StudentId
|
ExamScoreCT1
|
ExamScoreCT2
|
TotalMarks
|
1
|
87
|
75
|
100
|
2
|
68
|
77
|
100
|
3
|
76
|
91
|
100
|
4
|
88
|
56
|
100
|
we want to select greater marks between both of colums ExamScoreCT1 and ExamScoreCT2
query :
0 comments:
Post a Comment