ms sql left join group by的相關公司資訊
How do I perform a GROUP BY on an aliased column in MS-SQL Server? - Stack Overflow

How do I perform a GROUP BY on an aliased column in MS-SQL Server? - Stack Overflow

瀏覽:1019
日期:2024-08-12
I'm trying to perform a group by action on an aliased column (example below) but can't determine the proper syntax. SELECT LastName + ', ' + FirstName AS 'FullName' FROM customers GR... ... Sorry, this is not possible with MS SQL Server (possible though ....看更多