基于values的表表达式查询

SQL Server 2008中引入

SELECT *
FROM
(
VALUES
('tom', 18, 1),
('jerry', 19, 2),
('lanmao', 17, 3)
) oo (name, age, id);