Page 97 - Computer Software Application TP - Volume 1

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