Re: [GENERAL] Approach to extract top records from table based upon aggregate

2015-11-03 Thread Merlin Moncure
On Mon, Nov 2, 2015 at 4:14 PM, droberts wrote: > Hi, I have a table that contains call records. I'm looking to get only > records for users who made the most calls over a particular time duration in > an efficient way. > > calls() > > time, duration, caller_number, dialed_number > > > > -- qu

Re: [GENERAL] Approach to extract top records from table based upon aggregate

2015-11-02 Thread Emanuel Calvo
2015-11-02 19:14 GMT-03:00 droberts : > Hi, I have a table that contains call records. I'm looking to get only > records for users who made the most calls over a particular time duration > in > an efficient way. > > calls() > > time, duration, caller_number, dialed_number > > > > -- query to g

Re: [GENERAL] Approach to extract top records from table based upon aggregate

2015-11-02 Thread David G. Johnston
On Mon, Nov 2, 2015 at 3:14 PM, droberts wrote: > Hi, I have a table that contains call records. I'm looking to get only > records for users who made the most calls over a particular time duration > in > an efficient way. > > calls() > > time, duration, caller_number, dialed_number > > > > --