topproductsbyprice.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 14 行

USE Northwind
GO
DECLARE @numRows AS bigint;
SET @numRows = 10;
SELECT TOP (@numRows) * FROM Products
ORDER BY UnitPrice DESC
GO
DECLARE @pctRows AS float;
SET @pctRows = 12.5;
SELECT TOP (@pctRows) PERCENT * FROM Products
ORDER BY UnitPrice DESC
GO