Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Using TOP in mySQL v4.1
- Andrew Chalk
January 27, 2006, 1:12 am
rate this thread
Re: Using TOP in mySQL v4.1
Right -- TOP is not a keyword in MySQL or in standard SQL.
This is a proprietary extension to the SQL language, implemented in
Microsoft SQL Server 7 and later.
You can do this in MySQL as follows:
SELECT DISTINCT * FROM calldetails ORDER BY calldate DESC LIMIT 10
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum