Posts by Marco Altran • 141 points

• 4

  votes

  2

  answers

  81

  views

  A: which SQL command would display records where the Lastname field is "Duck" and the date in the Birthdate field is greater than 01/01/1950?

  SELECT * FROM table WHERE LastName = 'Duck' AND BirthDate > DATE('1950-01-01'); Where table is the table name. See * will show all fields, if you want something specific, replace * by the name of…

  mysql

  answered 10 years, 3 months ago Marco Altran 141