Page 98 - Computer Software Application TP - Volume 1
P. 98

COMPUTER SOFTWARE APPLICATION - CITS





















           4  Select with multiple conditions:
           SELECT * FROM your table name WHERE condition1 AND condition2;























           5  Select with ordering(ORDER BY clause):
           SELECT * FROM your table name ORDER BY your column name DESC;
           6  Select with a limit:
           SELECT * FROM your table name LIMIT 10;

           7  Select with a join:
           SELECT t1.column1, t2.column2
           FROM table1 t1
           JOIN table2 t2 ON t1.common column = t2.common column;
           8  Select with Aggregate functions (e.g. SUM, AVG):

           SELECT AVG(your column name) AS average value
           FROM your table name;
           SELECT MIN(your column name) AS minimum value
           FROM your table name;
           1  How to retrieve maximum and minimum values in any particular column?

           2   How to retrieve rows based on date range?
           3   How to retrieve unique values in any column?










                                                           83

                               CITS : IT & ITES - Computer Software Application - Exercise 26
   93   94   95   96   97   98   99   100   101   102   103