Friday, 22 June 2012

1.a) FROM & WHERE clause in SQL

SELECT name, age, salary
FROM employee
WHERE age > 50;

The above statement will select all of the values in the name, age, and salary columns from the employee table whose age is greater than 50.

Note: Remember to put a semicolon at the end of your SQL statements. The ; indicates that your SQL statment is complete and is ready to be interpreted.

Comparison Operators
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
<> or !=Not equal to
LIKEString comparison test

No comments:

Post a Comment