Skip to Content
0
Former Member
Jun 06, 2013 at 12:32 PM

"column is invalid in the select list"

53 Views

I just recently moved over to Sybase ASE after having used Microsoft SQL Server for many years. I notice that I'm no longer getting the error I occasionally got in SQL Server when using GROUP BY:

"xxxx" is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

I notice that when Sybase ASE is presented with a column in the SELECT clause that's not contained in either an aggregate function or the GROUP BY clause, rather than generating an error it simply returns all the potential rows with all possible values that it thinks you could be asking for. Am I wrong here? Is there a difference in how Sybase ASE SQL and Microsoft SQL handle this situation?