-
If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following query?
SELECT fruit FROM Employee
WHERE Emp_id=1
ORDER BY fruit;
-
- apple, banana, mango
- mango, apple, banana
- apple, mango, banana
- All of above
- None of these
Correct Option: A
ORDER BY Clause always sort in alphabetical order which also known as lexicographical order.
