programming-examples/11. Write a query in SQL to find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'.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

207 B

SQL

Raw Permalink Blame History

 /*11. Write a query in SQL to find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'.*/
 SELECT act_id
 FROM actor
 WHERE act_fname='Woody'
 AND act_lname='Allen';