Jump to content

Using Having On Sql


antgaudi

Recommended Posts

I have the following code:select pil_pilotname, pil_flight_payfrom pilotsgroup by pil_pilotname, pil_flight_payhaving pil_flight_pay > 2586.67/I wanted to use avg(pil_flight_pay) instead of 2586.67. SQL, however, does not allow.I'm trying to get the flight pays that exceed the average flight pay for all pilots.What should I modify?Thanks.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...