i wish use count value of table in search. how can do? query shows #1111 - invalid use of group function
select driver_details.driverid, count(taxi_trip.autoid) totaltrip, sum(taxi_trip.tripdistance) totaltripdistance, sum(taxi_trip.totalfare) totaltripfare driver_details left join taxi_trip on taxi_trip.driverid = driver_details.driverid , taxi_trip.pickuplat != 0 , taxi_trip.droplat != 0 , taxi_trip.totalfare != 0 (date_format(taxi_trip.requestdate,'%y-%m-%d') >= 2015-07-17) , (date_format(taxi_trip.requestdate,'%y-%m-%d') <= 2015-07-17) , (driver_details.driverid '%sa%' or driver_details.firstname '%sa%' or driver_details.lastname '%sa%' or driver_details.taxiplateno '%sa' or count(taxi_trip.autoid) '%sa%' or sum(taxi_trip.tripdistance) '%sa%' or sum(taxi_trip.totalfare) '%sa%') group taxi_trip.autoid
try rewriting using having
select driver_details.driverid, count(taxi_trip.autoid) totaltrip, sum(taxi_trip.tripdistance) totaltripdistance, sum(taxi_trip.totalfare) totaltripfare driver_details left join taxi_trip on taxi_trip.driverid = driver_details.driverid , taxi_trip.pickuplat != 0 , taxi_trip.droplat != 0 , taxi_trip.totalfare != 0 group taxi_trip.autoid having (date_format(taxi_trip.requestdate,'%y-%m-%d') >= 2015-07-17) , (date_format(taxi_trip.requestdate,'%y-%m-%d') <= 2015-07-17) , (driver_details.driverid '%sa%' or driver_details.firstname '%sa%' or driver_details.lastname '%sa%' or driver_details.taxiplateno '%sa' or count(taxi_trip.autoid) '%sa%' or sum(taxi_trip.tripdistance) '%sa%' or sum(taxi_trip.totalfare) '%sa%')
Comments
Post a Comment