Jump to content
php.lv forumi

xPtv45z

Reģistrētie lietotāji
  • Posts

    650
  • Joined

  • Last visited

Community Answers

  1. xPtv45z's post in group by izlaiž rezultātu was marked as the answer   
    To query iespējams uzrakstīt daudz vienkāršāku un ātrāku (sqlfiddlā uz tiem ierakstiem, 2ms pret 31ms)
    SELECT `person`.`name`, round(avg(`vehicle`.`cost`)) AS `avg_car` FROM `person` LEFT OUTER JOIN `vehicle` ON `person`.`id` = `vehicle`.`person_id` AND `vehicle`.`vehicle` = 'car' GROUP BY `person`.`id`
  2. xPtv45z's post in Fonta nomaiņa. was marked as the answer   
    @import url(http://fonts.googleapis.com/css?family=Cuprum:400,700&subset=latin,latin-ext,cyrillic); Nepalīdz?
×
×
  • Create New...