MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Newbie: Distinct count expression
Posted by: Vivek Budhram
Date: April 06, 2017 01:52AM

startdate duration agent disposition
2017-01-04 09:22:39 0 NOTANDOG 00-NAN
2017-01-18 14:06:44 1 NOXOLOD1 01-NPC
2017-01-04 09:22:32 5 NOTANDOG 01-NPC


Hi there,

Please assist with the above,

I am looking for the correct expression to run the following:

I would like to do distinct count on 'disposition' with start date >= 2017-01-01 00:00:00 and =< 2017-01-31 23:00:00

please help urgently

Thank you in advance

regards
Vpower

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Newbie: Distinct count expression
Vivek Budhram
April 06, 2017 01:52AM
Re: Newbie: Distinct count expression
Vivek Budhram
April 06, 2017 01:54AM
Re: Newbie: Distinct count expression
Vivek Budhram
April 06, 2017 04:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.