antgaudi Posted April 17, 2009 Share Posted April 17, 2009 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.