Structuring Database for Accounting

value is to be compared with an attribute, the value set can be given in Where clause by specifying IN operator. ( ) To retrieve Details of Accounts with following Codes: relating to “621001”, “632021” and “642002”. ( Model-I and Model-II ) SELECT * Accounts Code IN( “621001”,”632001”,”642002” ); ( ) To retrieve name of all employees who do not have supervisors. ( Model-I and Model-II ) SELECT * Employees SuperId = NULL; XI.

Aggregate Functions and Grouping : The concept of aggregate functions as referred to in relational operations, is implemented by SQL. Five such functions commonly used for aggregate of data items are: COUNT,SUM, MAX, MIN and AVG . These functions when applied on a set of numeric values, return respectively number of rows, the sum , maximum, minimum and average of these values. The GROUP BY clause is used for providing