如果第一条语句有结果,则执行,
如果第一条语句执行结果为空,则执行第二条语句
怎么写
SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESCSELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC
如果第一条语句执行结果为空,则执行第二条语句
怎么写
SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESCSELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC
SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESC
if @@rowcount>0
SELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC
select * from Table1
IF @@Rowcount = 0
select 123
SELECT TOP 1
*
FROM ( SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16' AND '2012-7-18'
) AS A
ORDER BY 数量 DESC
IF @@ROWCOUNT = 0
BEGIN
SELECT TOP 1
*
FROM TEST
ORDER BY 日期 DESC
END
如果是继续执行那么参考2、3楼
如果是第二个不执行
if exists(SELECT 1 FROM TEST WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18')
SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESC
elseSELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC
if exists(SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESC)
SELECT TOP 1 *
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESC
else
SELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC
FROM
(
SELECT *
FROM TEST
WHERE 日期 BETWEEN '2012-7-16'AND'2012-7-18'
) AS A
ORDER BY 数量 DESCif @@rowcount>0 --加个判断,使用ROWCOUNT之后可以很方便的
解决TOP要害字不能带变量的问题
SELECT TOP 1 *
FROM TEST
ORDER BY 日期 DESC