{"id":257,"date":"2007-10-02T16:29:00","date_gmt":"2007-10-02T19:29:00","guid":{"rendered":"http:\/\/helbertt.16mb.com\/site\/index.php\/2007\/10\/02\/limit-no-sql-server\/"},"modified":"2007-10-02T16:29:00","modified_gmt":"2007-10-02T19:29:00","slug":"limit-no-sql-server","status":"publish","type":"post","link":"https:\/\/helbertt.xyz\/site\/limit-no-sql-server\/","title":{"rendered":"Limit no SQL Server"},"content":{"rendered":"<p>Tava programando um poquim e me deparei com uma situa\u00e7\u00e3o meio constrangedora&#8230; sempre programei em php cpm banco de dados MySQL&#8230; mais agora to programando com o MSSQL e n\u00e3o sabia como limitar a quantidade de linhas no select. ent\u00e3o fiz esse select ai pra resolver o meu problema&#8230;<\/p>\n<blockquote><p><span style=\"color:#006600;\">SELECT *<br \/>FROM (SELECT top 10 *<br \/>FROM (SELECT TOP 20 *<br \/>   FROM Customers<br \/>      ORDER BY CustomerID ASC) AS t1<br \/>      ORDER BY CustomerID DESC) AS t2<br \/>ORDER BY CustomerID ASC<\/span><\/p><\/blockquote>\n<p>Seleciona 10 registros come\u00e7ando do vig\u00e9simo (inclusive) e descendo, ou seja entre os registros 11 e 20.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tava programando um poquim e me deparei com uma situa\u00e7\u00e3o meio constrangedora&#8230; sempre programei em php cpm banco de dados<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout"},"categories":[70,74,75],"tags":[],"_links":{"self":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/257"}],"collection":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/comments?post=257"}],"version-history":[{"count":0,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/257\/revisions"}],"wp:attachment":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/media?parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/categories?post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/tags?post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}