Bilgi: 12 Nisan 2010 Yazar: admin 0 yorumlar

This example shows the MS-SQL (Microsoft SQL-Server) counterpiece for the limit command of MySQL.

-- MS-SQL / SQL-Server 2005
SELECT TOP 15 * FROM ExampleTable WHERE Active = 1 ORDER BY Id DESC

-- MySQL
SELECT * FROM ExampleTable WHERE Active = 1 LIMIT 0,15 ORDER BY Id DESC

Linkler: Geri izleme Permalink Yorumlar için RSS
Del.icio.us Digg Technorati