{"id":182,"date":"2018-12-11T15:50:35","date_gmt":"2018-12-11T15:50:35","guid":{"rendered":"https:\/\/barkhane.com\/sql\/2018\/12\/11\/sql-select-count\/"},"modified":"2024-03-03T17:58:57","modified_gmt":"2024-03-03T17:58:57","slug":"sql-select-count","status":"publish","type":"post","link":"https:\/\/barkhane.com\/sql\/sql-select-count\/","title":{"rendered":"SQL SELECT COUNT"},"content":{"rendered":"

SQL SELECT COUNT : The\u00a0SQL COUNT()<\/strong>\u00a0function is used to return the number of rows in a query.<\/p>\n

The COUNT() function<\/a> is used with SQL SELECT statement and it is very useful to count the number of rows in a table having enormous data.<\/p>\n

For example:<\/strong>\u00a0If you have a record of the voters in selected area and want to count the number of voters then it is very difficult to do it manually but you can do it easily by using the SELECT COUNT query.<\/p>\n

Let\\’s see the syntax of SQL COUNT statement.<\/p>\n

\n
\n
\n
<\/div>\n<\/div>\n

SELECT<\/span>\u00a0COUNT<\/span>\u00a0(expression)<\/p>\n

FROM<\/span>\u00a0tables<\/p>\n

WHERE<\/span>\u00a0conditions;<\/p>\n<\/div>\n<\/div>\n

Let\\’s see the examples of sql select count function.<\/p>\n

\n

SELECT COUNT(column_name)<\/h4>\n
\n
\n
\n
<\/div>\n<\/div>\n

SELECT<\/span>\u00a0COUNT<\/span>(name<\/span>)\u00a0FROM<\/span>\u00a0employee_table;<\/p>\n<\/div>\n<\/div>\n

It will return the total number of names of employee_table. But null fields will not be counted.<\/p>\n

\n

SELECT COUNT(*)<\/h4>\n
\n
\n
\n
<\/div>\n<\/div>\n

SELECT<\/span>\u00a0COUNT<\/span>(*)\u00a0FROM<\/span>\u00a0employee_table;<\/p>\n<\/div>\n<\/div>\n

The \\”select count(*) from table\\” is used to return the number of records in table.<\/p>\n

\n

SELECT COUNT (DISTINCT column_name)<\/h4>\n
\n
\n
\n
<\/div>\n<\/div>\n

SELECT<\/span>\u00a0COUNT<\/span>(DISTINCT<\/span>\u00a0name<\/span>)\u00a0FROM<\/span>\u00a0employee_table;<\/p>\n<\/div>\n<\/div>\n

It will return the total distinct names of employee_table.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

SQL SELECT COUNT : The\u00a0SQL COUNT()\u00a0function is used to return the number of rows in a query. The COUNT() function […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":0,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"wp:attachment":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}