kts Posted May 18, 2010 Share Posted May 18, 2010 If I'm querying the following through an API returning XML.. SELECT Count(DISTINCT StudentID) FROM Credits WHERE Type = 'Credits' AND Mark > 65 AND Mark < 85 is there a way to also return the number Mark > 85 in the same query Seperately*!? Link to comment https://forums.phpfreaks.com/topic/202188-multiple-returns-with-specific-where-statements/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.