매일 성장하자!!

SQL SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name='Russia') SELECT population FROM world where name = 'Russia' 서브쿼리의 결과는 단일 값이다. 즉 위의 쿼리는 SELECT name FROM world WHERE population > 146745098; 아래 쿼리와 같다. select name from world where continent = 'Europe' AND gdp / population > (select gdp / population from world where name = 'United K..

SQL SELECT yr, subject, winner FROM nobel WHERE yr = 1950 SELECT winner FROM nobel WHERE yr = 1962 AND subject = 'Literature' select yr, subject from nobel where winner = 'Albert Einstein'; select winner from nobel where yr >= 2000 AND subject = 'Peace'; select * from nobel where subject = 'Literature' AND yr between 1980 AND 1989;between A AND B 는 A와 B를 포함함 SELEC..