SQL面试题：有A B C三列,用SQL语句实现：当A列大于B列时选择A列否则选择B列

1. drop table table1

2. create table table1(

3. a int,

4. b int,

5. c int

6. )

7. insert into table1 values(22,24,23)

8.  

9. select * from table1

10.  

11. select (case when a>b then a else b end),(case when b>c then b else c end)

12. from table1

13.  

14. select (case when a>b then a

15. when a>c then a

16. when b>c then b else c

17. end)

18. from table1