SQL语句练习 自学SQL网 基础查询

目录

Day1 简单条件查询

Day2 简单条件查询

Day3 复杂条件查询

Day4 查询结果 Filtering 过滤和 sorting 排序

Day5 SELECT综合条件查询

Day1 简单条件查询

SELECT Title FROM movies;

SELECT Director FROM movies;

SELECT Title , Director FROM movies;

SELECT Title ,Year FROM movies;

SELECT * FROM movies;

SELECT Title , Id , Length_minutes FROM movies;

Day2 简单条件查询

·

SELECT * FROM movies WHERE Id=6;

SELECT * FROM movies WHERE year BETWEEN 2000 AND 2010;

SELECT * FROM movies WHERE year NOT BETWEEN 2000 AND 2010;

SELECT * FROM movies ORDER BY Id LIMIT 5;

SELECT * FROM movies 
	WHERE Year >=2010
    AND Length_minutes <120

Day3 复杂条件查询

SELECT * FROM movies WHERE Title LIKE "%Toy Story%";

SELECT * FROM movies WHERE Director = "John Lasseter";

SELECT * FROM movies WHERE Director !="John Lasseter";

SELECT * FROM movies WHERE Title LIKE "WALL-%";

SELECT * FROM movies WHERE Year = 1998 
					AND Title = "A Bug's Life";

Day4 查询结果 Filtering 过滤和 sorting 排序

SELECT DISTINCT Director FROM movies ORDER BY Director ASC;

SELECT * FROM movies ORDER BY Year DESC LIMIT 4;

SELECT * FROM movies ORDER BY Title ASC LIMIT 5;

SELECT * FROM movies ORDER BY Title ASC LIMIT 5 OFFSET 5 ; 

SELECT Title FROM movies WHERE Director = "John Lasseter" 
						 ORDER BY Length_minutes ASC 
                		 LIMIT 1 OFFSET 3;

Day5 SELECT综合条件查询

SELECT * FROM north_american_cities WHERE Country = "Canada";

SELECT * FROM north_american_cities 
         WHERE Longitude
         >
        (SELECT Longitude FROM north_american_cities WHERE City = "Chicago")
        ORDER BY Longitude ASC

SELECT * FROM north_american_cities 
	    WHERE Country="Mexico"
        ORDER BY Population DESC
        LIMIT 2;
 
SELECT * FROM north_american_cities 
		WHERE Country=="United States"
        ORDER BY Population ASC
        LIMIT 2 OFFSET 2;