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] )
Комментариев нет:
Отправить комментарий