How to count all unique records in the SQL table?
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
Jr. Software Developer
I am a software developer at MindStick soft. Pvt. ltd. I joined this company in august 2021 after completing my post-graduation course. I love to see the historical places of my country.
Can you answer this question?
Write Answer1 Answers
We can count all unique records in a table using the DISTINCT keyword in conjunction with the COUNT() aggregate function.
The DISTINCT keyword in a query retrieves different and non-repeating values.
The COUNT() function returns the number of rows selected by a query.