Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Need to Improve Performance

by Anonymous Monk
on Jan 03, 2014 at 08:39 UTC ( #1069105=note: print w/ replies, xml ) Need Help??


in reply to Need to Improve Performance

I haven't worked with sql for a while but are you sure this is correct?

select max(count(pan_id)) from seg_dtl_panelist where seg_id ='1' group by seg_dtl_id, seg_id

This seens wrong: max(count(pan_id), as count will return 1 value.


Comment on Re: Need to Improve Performance
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (12)
As of 2015-07-29 18:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (267 votes), past polls