which SQL command would display the records where the LastName field is "Duck" and the date in the BirthDate field is greater than 01/01/1950?

Question

which SQL command would display the records where the LastName field is "Duck" and the date in the BirthDate field is greater than 01/01/1950?

Navigation

#1 by (5 votes)
#2 by (4 votes)

2

Given the table, what SQL statement would display the records where the LastName field is "Duck" and the date in the BirthDate field is greater than 01/01/1950?

mysql

asked by anonymous 30.08.2014 / 01:36

2 answers

Include link if it is first element How to get the next element in a foreach in PHP

score 5 · Answer 1

Assuming the name of the table in question is "myTable":

select
  *
from mytable
where lastname = 'Duck'
  and birthdate > '1950.01.01'

Tested command in MySQL 5.5.

Note: Whenever possible, I recommend formatting the command. For extended commands this custom is essential to avoid wrong constructions and to facilitate maintenance.

score 4 · Answer 2

SELECT * FROM table WHERE LastName = 'Duck' AND BirthDate > DATE('1950-01-01');

Where table is the name of the table. Note that * will show all fields, if you want something specific, replace * with the desired field name. Note that the date format in the command must be the same as the BirthDate field format.