w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
How can I ORDER the result after i've used LIMIT?

if you want to get the last four rows from table

select * from table  order by date desc limit 0,4

if you want to get the first four rows from table

select * from table  order by date asc limit 0,4




© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.