SQL Interview question: there is a B C three column, implemented with SQL statement: When column A is greater than column B, select column B otherwise

Ask a query question for an SQL statement that was encountered during an interview
The table has a B C three column, implemented with the SQL statement: When column A is greater than column B, select column B, or column B if column B is greater than column C, select column C otherwise.
------------------------------------------
Select (case if A>b then a else B end),
(case is b>c then B esle C end)
From table_name

[SQL]View PlainCopy

2. Drop Table table1
4. Create table table1 (
6. A int,
8. b int,
10. C int
12. )
14. INSERT INTO table1 values (22,24,23)
18. SELECT * FROM table1
22. Select (case is a>b then a else B end), (case isb>c then b else C end)
24. From table1
28. Select (case if a>b then a
30. When A>c then a
32. When b>c then b else C
34. end)
36. From table1
    

SQL Interview question: there is a B C three column, implemented with SQL statement: When column A is greater than column B, select column B otherwise