Q. What will the following query return?

Code: 
SELECT COUNT(*) FROM users;
  • (A) Sum of all column values
  • (B) Number of users
  • (C) Maximum ID
  • (D) Names of users
💬 Discuss
✅ Correct Answer: (B) Number of users
Explanation: `COUNT(*)` counts the total number of rows in the `users` table.

Published by Mr. Dubey ⭐ 111.42K Points at 06-Jun-2025 09:40 pm in MySQL

Explanation by: Mr. Dubey
`COUNT(*)` counts the total number of rows in the `users` table.

💬 Discussion

📊 Question Analytics

👁️
94
Total Visits
📽️
1 y ago
Published
🎖️
Mr. Dubey
Publisher
📈
95%
Success Rate