Which two aggregate functions are valid on the START_DATE column if - ProProfs Discuss
Advertisement

Which two aggregate functions are valid on the START_DATE column if we examine the description of the STUDENTS table:STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE?

Asked by Kabirkhanna, Last updated: Apr 13, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

Peter

Peter

Peter
Peter

Answered Jun 19, 2018

COUNT is used for counting, not aggregating. It counts rows, not columns. You could syntax it like count(*), count(1) or count(100), it still would give you the same result. Crappy question... again

upvote downvote
Reply 

kabirkhanna

kabirkhanna

kabirkhanna
Kabirkhanna

Answered Jun 19, 2018

COUNT(start_date)
MIN(start_date)
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.