Baking SQL: Perfecting the elements

Photo by Fabrizio Magoni on Unsplash

This blog covers some of the concepts as well as applications of the SQL queries and clauses. I will keep on updating the blog as and when I get more time or I learn newer concepts.

  • SELECT — The result of a SELECT statement is another table known as result set. It can retrieve either rows or columns from a table. The clauses in the SELECT statement must be written in the syntactical order below:
    SELECT select_list
    FROM table
    WHERE condition
    GROUP BY expression
    HAVING condition
    ORDER BY expression
  • WHERE — It defines one or more conditions that limit the selected rows. It specifies a boolean expression.
  • DISTINCT — It can be used only once in a SELECT list and it must precede all column names in that list. When there is more than one column in the SELECT list, the DISTINCT clause displays all rows where the combination of columns is distinct.
  • Boolean Operations — Priority: NOT>AND>OR.
  • IN — It allows the specification of two or more expressions to be used for a query search. An IN operator is equivalent to a series of conditions, connected with one or more OR operators.
  • BETWEEN — It specifies a range of values which determine the upper and lower bounds of the qualifying value. Note that the bounds are inclusive.

--

--

--

Collecting data nuts, one at a time!

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

SSH Tunnels

A guide to Apdex score: Calculations, improvements, and more

CountDownLatch In Java

Create a Voice Calculator App | app inventor 2

AV Player Mobile App using Flutter

PoolTogether vs. Entropyfi

Basic of Git — Explain with Google Drive Versioning

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
The Data Squirrel

The Data Squirrel

Collecting data nuts, one at a time!

More from Medium

Code Quality Analysis

3 Things I Didn’t Know You Could Do With SQL

Why can’t I find my files?

NHL API: what data is exposed and how to analyse it with Python