ORDER BY  LIMIT  SQL. 18   
 


   ORDER BY  LIMIT  SQL     .  18    :  ,  ,  ,   OFFSET,   ,   CASE, NULL  ,        .     SQLite.





 

ORDER BY  LIMIT  SQL. 18   





  





     


ORDER BY     ,       ,     ,          .

LIMIT      :      ,       .

        ,      :  ,  ,    .




  


         : , , ,     .

      ,   ORDER BY.     ,       .

    SQLite.  ORDER BY, LIMIT, OFFSET, CASE        SQL-.




  


1.      (#task-1)

2.    (#task-2)

3.  -3    (#task-3)

4.     (#litres_trial_promo)

5.      (#litres_trial_promo)

6.     (#litres_trial_promo)

7.  NULL    (#litres_trial_promo)

8.       (#litres_trial_promo)

9.    (#litres_trial_promo)

10.      (#litres_trial_promo)

11.      (#litres_trial_promo)

12.      (#litres_trial_promo)

13.       (#litres_trial_promo)

14.     (#litres_trial_promo)

15.   (#litres_trial_promo)

16.     (#litres_trial_promo)

17.     (#litres_trial_promo)

18.      (#litres_trial_promo)




 





 1.     



 

   ,       .




CREATE TABLE orders(id INTEGER, total INTEGER);

INSERT INTO orders VALUES (1,300),(2,900),(3,500),(4,1200);




SELECT id, total

FROM orders

ORDER BY total DESC;


 

[[4, 1200], [2, 900], [3, 500], [1, 300]]


 

ORDER BY total DESC      .

 4  ,    .

 1     .


  

 DESC     ,        .


 

   700.     ?

:    900  500,       total.




 2.   



 

    ,        .




CREATE TABLE orders(id INTEGER, total INTEGER, order_date TEXT);

INSERT INTO orders VALUES

(1,500,'2026-09-03'),

(2,900,'2026-09-01'),

(3,500,'2026-09-01'),

(4,900,'2026-09-02');




SELECT id, total, order_date

FROM orders

ORDER BY total DESC, order_date ASC, id ASC;


 

[[2, 900, "2026-09-01"], [4, 900, "2026-09-02"], [3, 500, "2026-09-01"], [1, 500, "2026-09-03"]]


 

    total    .

       .

id       .


  

   ORDER BY total DESC,         .


 

  2    4,     ?

:     order_date ASC  2026-09-01  2026-09-02.




 3.  -3   



 

      ,     .




CREATE TABLE products(sku TEXT, revenue INTEGER);

INSERT INTO products VALUES ('A1',300),('B2',900),('C3',500),('D4',1200),('E5',100);







  .


   .

   ,     (https://www.litres.ru/book/raznoe/order-by-i-limit-v-sql-18-zadach-na-sortirovku-74419514/)  .

      Visa, MasterCard, Maestro,    ,   ,     ,  PayPal, WebMoney, ., QIWI ,       .


