mysql - Select a specific number of records from a record -


i have query working need show 4 record record 5 of database?

how query look?

select   noticias.id,          idn,          titulo,          chamada,          foto_a,          subcatid,          noticias_subcategorias.subcategoria,          slug,          noticias.rlogdata     noticias,          noticias_subcategorias    noticias.subcatid = noticias_subcategorias.id          , noticias.status = 1          , posicao = 1          , noticias.tipo = 2 order idn desc limit 0, 4 

thanks.

if want start @ record 5, you'd use limit 4 offset 4 skip first 4 records.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -