SQL Query

SQL Query

1. 1.Select

   • SELECT FROM table WHERE Column_N = 'a'
     • SELECT name, population FROM world WHERE name IN ('Brazil', 'Russia');
       • Select Department FROM MyCompany WHERE Salary BETWEEN 1000 AND 5000
         • Select Department FROM MyCompany WHERE Department LIKE 'A%' ('%C%', '%E')
           • Select Department, SAlary/WorkingHours FROM MyCompany WHERE Salary > 3000
             • SELECT yr, subject, winner FROM nobel WHERE subject= 'Literature ' and yr >=1980 and yr<=1989
               • SELECT yr,subject,winner FROM nobel WHERE subject = 'Physics' and yr = 1980 or subject = 'Chemistry ' and yr = 1984
                 • SELECT yr,subject,winner FROM nobel WHERE yr = '1980' and subject not in ('Chemistry', 'Medicine')
                   • SELECT * FROM nobel WHERE winner LIKE 'Sir%' ORDER BY yr DESC, winner
                     • SELECT column1, column2, ... FROM table_name ORDER BY column1, column2, ... ASC|DESC;
                       • SELECT winner, subject FROM nobel WHERE yr=1984 ORDER BY subject IN ('Physics','Chemistry'),subject,winner
                         • SELECT name,length(name) FROM world WHERE length(name)=5 and region='Europe'
                           • Select COUNT(Department) FROM MyCompany WHERE Salary BETWEEN 3000 AND 4000
                             • Select DISTINCT(Department) FROM MyCompany
                               • SELECT name, CONCAT(ROUND(100*population/(SELECT population From world Where name = 'Germany')),'%') FROM world WHERE continent = 'Europe'
                                 • SELECT SUM(population) FROM world
                                   • SELECT continent, count(name) FROM world GROUP BY continent
                                     • SELECT mdate, team1, CASE WHEN teamid=team1 THEN 1 ELSE 0 END score1 FROM game JOIN goal ON matchid = id