美文网首页
【SQL】6.SQLZOO练习1--SELECT basics

【SQL】6.SQLZOO练习1--SELECT basics

作者: 一曈 | 来源:发表于2017-06-05 13:10 被阅读16次

    题目链接:https://sqlzoo.net/wiki/SELECT_basics

    select basics 1
    SELECT population FROM world
    WHERE name = 'Germany'
    
    select basics 2
    select name,population from world
    where name in ('Sweden', 'Norway', 'Denmark')
    
    select basics 3
    SELECT name, area FROM world
    WHERE area BETWEEN 200000 AND 250000
    

    相关文章

      网友评论

          本文标题:【SQL】6.SQLZOO练习1--SELECT basics

          本文链接:https://www.haomeiwen.com/subject/omuifxtx.html