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*!? Quote Link to comment https://forums.phpfreaks.com/topic/202188-multiple-returns-with-specific-where-statements/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.