Querries

Welcome to SQL Journey!!

This page outlines queries.

SQLite

Table Commands:

create table, alter table, drop table, view table [as], select, insert, truncate, union [all], except, intercept, update, delete

SQL Clauses

distinct, from, where, order by, group by, having

SQL Functions, e.g.

count, sum, min, max, avg, etc.

SQL Conditions

and, or, like, in, not, is null, is not null, between, exists, ==, <>, !=, etc.

SQL Datatypes

text, integer, numeric, real, none

Text Types

char(s), varchar(s), tinytext(s), text(s), mediumtext(s), longtext(s), nchar(s), nvarchar(s), clob(s),

Numeric Types

integer, numeric, real, date, datetime, timestamp, time

SQLite3 Querries

select [distinct] [columns or *]
  from [table in db] as [local_name]
  where [condition]