|
|
SQL Tutorial
SELECT statement with WHERE condition
The conditional clause used with WHERE keyword selects only those
statements which match the criteria specified in the WHERE clause.
|
|
All Relational and logical operators like
>,<,>=,<=,=,<>,AND,OR,BETWEEN,LIKE are permitted
Example 4:
SELECT * FROM Employee WHERE Age >=50;
RESULT
Waugh Steve 58
Clove Mark 65
|
The INSERT INTO Statement
The INSERT INTO statement is used to insert data into a table in a row.
Syntax
INSERT INTO table_name
VALUES (value1, value2,....)
OR
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
Example 5:
INSERT INTO Employee VALUES ('Peterson','John','49');
OR
INSERT INTO Employee (LastName,FirstNAme,Age) VALUES
('Peterson','John','49')
Go To
Index
|
|
|
