Q. Which Clause is used to sort the stored data in alphabetical order?

  • (A) ORDER by CLAUSE
  • (B) MODIFY
  • (C) ALTER
  • (D) UPDATE
💬 Discuss
✅ Correct Answer: (A) ORDER by CLAUSE
Explanation: To sort the stored data in alphabetical order in MySQL, you use the ORDER BY clause. This clause is used in SELECT queries to sort the result set based on specified columns, either in ascending (default) or descending order. Therefore, Option A is the correct answer.

Published by Ranjeet ⭐ 34.60K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Ranjeet
To sort the stored data in alphabetical order in MySQL, you use the ORDER BY clause. This clause is used in SELECT queries to sort the result set based on specified columns, either in ascending (default) or descending order. Therefore, Option A is the correct answer.

💬 Discussion

📊 Question Analytics

👁️
121
Total Visits
📽️
1 y ago
Published
🎖️
Ranjeet
Publisher
📈
96%
Success Rate