Question 4:- SQL MCQs

[Team AHT]

Q.. SELECT *
FROM abc
ORDER BY
CASE
WHEN condition1 THEN column1
WHEN condition2 THEN column2
ELSE column3
END;
1. We can not use Case satement in Order by clause here.
2.This Select query will give results.
3.Removing End staement will work.
4.None of These

[Author]

Posts