programming-examples/Write a SQL query to show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

5 lines

228 B

SQL

Raw Permalink Blame History

 /* Write a SQL query to show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics.*/
 SELECT *
  FROM nobel_win
    WHERE year=1970
     AND subject NOT IN('Physiology','Economics');