In MS SQL Server (starting from 2008) it is possible to use a row valued constructor as a derived table. The possible scenarios are:
select distinct * from (values (1), (1), (1), (2), (5), (1), (6)) as X(a)
select * from (values (1, 'User1'), (2, 'User2'), (3, 'User3'), (4, 'User4')) AS [Users] ( [Id], [Login] )
Комментариев нет:
Отправить комментарий