The PostgreSQL COUNT() function is applied to the commission column along with the DISTINCT clause. 3) COUNT() DISTINCT SELECT COUNT(DISTINCT designation) It will return the total count of the non-null values in the commission column i.e., it will give the count of the employees who only earn a commission. The PostgreSQL COUNT() function is applied to the commission column. 2) COUNT() on Specific Column SELECT COUNT(commission) This function will return the total number of records in the Employees table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |