SQL for Dummies in 60 seconds
A database is a collection of related information. SQL is a tool to work with databases. It consists of 3 components. Data Manipulation Language (DML), (select update insert delete) Data Definition Language (DDL), (create table, drop table) Data Control Language (DCL). (set access rights) SQL query analyser is the front end application to send queries to server. SELECT statement : SELECT column1,column2 FROM table returns the corresponding columns from the table. OPTIONAL CLAUSES. where group by(space included) --data into groups having --with group by to give condition 4 columns order by(space included) --condition to sort query results select price from table1 where price>200 select col1,col2 from table1 order by col1 ASC (DESC for decending) group by combines aggregate and non aggregate columns in same SELECT stmnt. SELECT itemnumber,sum(price) FROM sales GROUP BY itemnumber gives the sum of price of each occurence of the itemnum...