如何编写(MySQL)"LIMIT"在SQL Server中?

本文介绍了如何编写(MySQL)"LIMIT"在SQL Server中?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

当我尝试将带有LIMIT的查询从MYSQL更改为SQL Server时，我遇到了问题.

I have a problem when i try to change a query with LIMIT from MYSQL to SQL-Server.

检查:

SELECT * FROM tableEating WHERE person = '$identity' LIMIT 1;

我尝试通过一些查询来更改它，但是没有任何效果.

I tried to change it with some queries but nothing work.

推荐答案

LIMIT在T-SQL中不起作用.

LIMIT does not work in T-SQL.

您必须改为使用TOP，例如:

You have to use TOP instead, like this:

SELECT TOP(1) * FROM tableEating WHERE person='$identity';

我希望这对您有用.

正如亚伦所说，如果您不想获得任意行，还需要一个ORDER BY.

As Aaron says, you also need an ORDER BY if you don't want to get an arbitrary row.