SQL Clauses

SQL Clauses

Characterize SQL provisions: Here, we will find out about where conditions, bunch by provisos, having statements, request by provisos

SQL Clauses

SQL provisions are the exceptional/save words, which have a particular importance in a SQL language.

Note: We ought to like to compose provisos in capital letters yet it isn’t obligatory.

1) WHERE Clause

Where statement is utilized to get a contingent record. We should actualize where proviso at whatever point condition required.

Syntax:

SELECT col1,col2 FROM tablename WHERE col1 = value;

2) GROUP BY Clause

Gathering BY conditions is utilized to bring a gathering record. We should execute GROUP BY provisos at whatever point gathering required.

Gathering BY statements is utilized to orchestrate comparable records into gatherings.

Syntax:

SELECT col1,col2 FROM tablename GROUP BY columnname;

3) HAVING Clause

HAVING statements is utilized to bring a restrictive record in the wake of collection. We should actualize HAVING provisions at whatever point condition required in the wake of collection.

HAVING provisos chips away at those columns which returned by GROUP BY statements.

Syntax:

SELECT col1,col2.....coln 
FROM tablename 
WHERE colname = value 
GROUP BY colname 
HAVING colname = value;

4) Request BY Clause

Request BY provisos is utilized to bring arranged record. We should execute ORDER BY provisos at whatever point arranging required.

Request BY provisions is utilized to sort records either in ascending(ASC) or sliding order(DESC) in light of at least one section.

Syntax:

SELECT col1,col2.....coln 
FROM tablename 
WHERE colname = value 
GROUP BY colname 
HAVING colname = value 
ORDER BY columname (asc/desc);

DURGESH

I Love python, so I like machine learning a Lot and on the other hand, I like building apps and fun games I post blogs on my website for Tech enthusiast to learn and Share Information With The World.

Leave a Reply

Your email address will not be published. Required fields are marked *

2 × four =

Recent Content