Database Simple Query

1, the simplest query:

SELECT * from Car;

2, Query Development column:

Select name oil,powers from car;

3, change the name of the listed names:

Select name as ' car name ', oil as ' fuel consumption ', powers as ' power ' from car;

4. Search by Condition:

Select Name,oil,powers from car where oil = 8.7;

5, multi-criteria query:

Select Name,oil,powers from car where oil = 8.7 or powers = 160;
Select Name,oil,powers from car where oil = 8.7 and powers = 160;

6. Scope Query:

SELECT * from car where price>=40 and price <=60;
SELECT * from car where price between and 60;

7. Discrete query:

SELECT * from car where powers = Powers = or powers = 170;
SELECT * from car where powers in (130,150,170);
SELECT * from car where powers not in (130,150,170);

8, Fuzzy query:

SELECT * from car where name like '% BMW% ';
SELECT * from car where name like ' _ BMW% ';

9. Sort query: ASC Ascending desc descending order BY

SELECT * FROM car order by oil ASC;
SELECT * FROM Car ORDER by brand Asc,price desc;

10, to repeat the query: distinct

Select distinct brand from car;

11, paging query:

SELECT * FROM Car limit 5, 5;
N;m = 5;
Limit (n-1) *m,m; Added

12. Aggregate function Query:

Count (column name) sum (column name) AVG (column name) max (column name) min ()
Select COUNT (*) from car;
Select SUM (price) from car;
Select AVG (price) from car;
Select Max (price) from car;
Select min (price) from car;

　

Database Simple Query