Page 318 - IT 402 v2.0 class 10
P. 318
OPERATORS DESCRIPTION MP
Checks if value of ‘a’ is less than or equal to value of ‘b’. If
‘<=’ a b is true.
yes, condition becomes true, else false.
Checks if value of ‘a’ is less than value of ‘b’. If yes, condition
‘<’ a b is true.
becomes true, else false..
Checks if value of ‘a’ is not less than value of ‘b’. If yes,
‘!<’ a b is false.
condition becomes true, else false.
Checks if value of ‘a’ is greater than or equal to value of ‘b’.
‘>=’ a b is false.
If yes, condition becomes true, else false.
Checks if value of ‘a’ is not greater than value of ‘b’. If yes,
‘!>’ a b is true.
condition becomes true.
S ogical erators
OPERATORS DESCRIPTION
ALL It is used to compare a value to all values in another value set.
AND It allows the existence of multiple conditions in SQL statement.
ANY It compares the value in list according to the condition.
BETWEEN It is used to search for values within the set of values.
NOT It reverses the meaning of any logical operator.
OR It is used to combine multiple conditions in SQL statements.
T T
Table is a collection of organised data in the form of rows and columns. It is used to represent the relations.
STUDENT_NAME ADDRESS PHONE
Sanjay Jain Pune 9800000000
Abhijit Kundu Delhi 9100000000
S reate Ta le ommand
SQL Create Table statement is used to create a table in database. To create a table, assign a name to the table
and then define columns and the data types of each column.
S nta :
CRE AT E T AB L E T AB L E _ NAM E
(
colu mn_ name1 d ata_ ty p e ( siz e) ,
colu mn_ name2 d ata_ ty p e ( siz e) ,
colu mn_ name3 d ata_ ty p e ( siz e) ,
.....
.....
colu mn_ nameN d ata_ ty p e ( siz e)
) ;
316 Touchpad Information Technology-X

