Sunday, February 23, 2020

GROUPING and SORTING the same column of a table by SQL


How to group and sort the same column in a table https://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php

Counting the number of times a particular value appears in a column

select studentID, 15*count(*) as Fees FROM orders GROUP BY studentID;

No comments:

Post a Comment

Derivatives stock list at NSE

Complete FNO stock list at NSE. ABB India Ltd ACC Ltd APL Apollo Tubes Ltd AU Small Finance Bank Ltd Aarti Industries Ltd Abbott India Ltd A...