SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_8

8. Doing More with Queries

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

SQL as a language was created for the end users of the database systems. It just happened to be used by programmers too, but the goal was always a simple, declarative, English-like language to allow anybody familiar with computers and the domain to make sensible reports out of the database system. These reporting capabilities were the direct output of an SQL query, and thus from the very beginning, there have been a lot of options and clauses that can be used with SELECT to make the output more legible.

We have already seen some basic queries, how to order the results of a query, and how to put conditions ...