Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: To find the no of occurenaces and max min value

by sundialsvc4 (Abbot)
on Jul 14, 2014 at 13:18 UTC ( [id://1093548]=note: print w/replies, xml ) Need Help??


in reply to To find the no of occurenaces and max min value

Good grief, let’s just strip this down to SQL, because that’s all you need to do:

SELECT
  MIN(Time_Taken) AS Minimum,
  MAX(Time_Taken) AS Maximum,
  COUNT(DISTINCT Person_ID) AS Number_of_Occur
FROM ...
GROUP BY person_id

Sounds rather suspiciously like homework to me, because a trivial Pure-SQL solution does exist.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1093548]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (3)
As of 2024-03-19 05:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found