Clause similar to MySQL's LIMIT in MSSQL

Question

Clause similar to MySQL's LIMIT in MSSQL

Navigation

#1 by (5 votes)
#2 by (4 votes)

5

I need to run the query below in PHP with SQL Server, however I can not use the LIMIT clause missing in Microsoft queries .

$SqlTabelaAtual="SELECT * 
         FROM BusinessCadTabPreco
         RIGHT JOIN BusinessCadTabPrecoItem ON BusinessCadTabPreco.CdTabela = BusinessCadTabPrecoItem.CdTabela
         WHERE  BusinessCadTabPreco.CdEmpresa =01
         AND CdProduto =".$row['CdProduto']."
         ORDER BY  BusinessCadTabPreco.DtSincronizar DESC LIMIT 1

php sql sql-server sintaxe select-limit

asked by anonymous 15.01.2016 / 15:17

2 answers

4

Depending on the case TOP is suitable for limiting rows of a query, in more recent versions there are other more flexible clauses.

SELECT TOP 10 * FROM tabela.

15.01.2016 / 15:21

Definition of EJB Close PDO connection

score 5 · Accepted Answer

SQL Server uses the syntax TOP :

$SqlTabelaAtual="SELECT TOP 1 * 
         FROM BusinessCadTabPreco
         RIGHT JOIN BusinessCadTabPrecoItem ON BusinessCadTabPreco.CdTabela = BusinessCadTabPrecoItem.CdTabela
         WHERE  BusinessCadTabPreco.CdEmpresa =01
         AND CdProduto =".$row['CdProduto']."
         ORDER BY  BusinessCadTabPreco.DtSincronizar DESC

The 2012 and later versions allow ANSI syntax with OFFSET FETCH .