Select from following answers:- SELECT FruitName FROM Fruit
- SELECT FruitName FROM Fruit GROUP BY FruitName
- SELECT FruitName FROM Fruit ORDER BY FruitID
- All Above
GROUP BY clause internally orders(sorts) the result set.. Most of the interviewers will frequently ask this kind of logical questions...
By looking at answers set obviously users will select 3rd one as answer.. Before answering a question we should be very careful.
Here 3rd is incorrect answer because final result will be based on FruitID, but not FruitName
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator