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

COMPUTER SOFTWARE APPLICATION - CITS




           EXERCISE 26 : Simple Select Queries


            Objectives

            At the end of this exercise you shall be able to
           •  retrive data from the table
           •  retrive data from the table by using where clause
           •  retrive data from the table by using aggregate functions.

           Requirements



           Tools/Materials
           •   Desktop/Laptop with latest configuration
           •   Operating system: window 10:11
           •  XAMPP server r3.3.0


           Procedure

           TASK 1 :Using select queries:

           1  Select all columns from a table:
           SELECT * FROM your table name;



















           2  Select specific columns from a table:
           SELECT column1, column2 FROM your table name;


















           3  Select with a condition(WHERE clause):
           SELECT * FROM your table name WHERE your column name = ‘some value’;





                                                           82
   92   93   94   95   96   97   98   99   100   101   102