Unformatted text preview: DAYOFMONTH(birthdate) = 14 use numbers so 14 would signify the fourteenth day of the month YEAR(NOW())-YEAR(birthdate) AS age Will take current year (i.e. 2007) and subtract from birth year to calculate an age Other Functions usually used together: (all these will be introduced on Thursday) MIN(DigitalFilesize) AS smallest Will give the minimum filesize found COUNT(SecondaryArtistID) AS NumberofSecondaryArtists Will calculate how many SecondaryArtistID records have been filled in AVG(DigitalFilesize) AS AverageSize Will calculate the average size of the files MAX(DigitalFilesize) AS largest Will give the maximum filesize found...
View Full Document
This note was uploaded on 03/19/2008 for the course CSE 101 taught by Professor Allusethis during the Spring '08 term at Michigan State University.
- Spring '08