Various Syntax in SQL

Various Syntax in SQL 
All the examples given in this tutorial have been tested with a MySQL server.

SQL SELECT Statement 

SELECT column1, column2....columnN
FROM table_name;

SQL DISTINCT Clause

SELECT DISTINCT column1, column2....columnN
FROM table_name;

SQL WHERE Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION;

SQL AND/OR Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION-1 {AND|OR} CONDITION-2;

SQL IN Clause
SELECT column1, column2....columnN
FROM table_name
WHERE column_name IN (val-1, val-2,...val-N);

SQL BETWEEN Clause 
SELECT column1, column2....columnN
FROM table_name WHERE column_name
BETWEEN val-1 AND val-2;

SQL LIKE Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE column_name LIKE { PATTERN };

SQL ORDER BY Clause 
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION
ORDER BY column_name {ASC|DESC};

SQL GROUP BY Clause
SELECT SUM(column_name)
FROM table_name
WHERE CONDITION
GROUP BY column_name;

SQL COUNT Clause 
SELECT COUNT(column_name) FROM table_name
WHERE CONDITION;

CBSE || ICSE BOARD RESULT

CBSE/ICSE BOARD RESULT 2016-17

STUDENT NAME	CLASS	SCHOOL NAME	MARKS
RIDHDHIK DAS	IV	ADITYA ACADEMY	100%
SAGNIK	VI	ST JUGES SCHOOL	94%
CHANDRIMA KUNDU	VII	Julien Day School	99%
JAYASHREE SAHA	VII	ADITYA ACADEMY	98%
SRIJON BISWAS	VII	ADITYA ACADEMY	90%
URBASHI CHAKRABORTY	VII	Indira Gandhi Memorial High School	85%
DEEP SAHA	VII	ADITYA ACADEMY	84%