Advertisement
Guest User

Untitled

a guest
Jun 20th, 2023
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  SELECT m.id                              
  2.             FROM test_data AS m
  3.             ORDER BY m.email_address desc
  4.             OFFSET 0
  5.             LIMIT 1;
  6.    id  
  7. --------
  8.  269049
  9. (1 row)
  10.  
  11.  
  12.  SELECT m.id                              
  13.             FROM test_data AS m
  14.             ORDER BY m.email_address desc
  15.             OFFSET 0
  16.             LIMIT 2;
  17.    id  
  18. --------
  19.  271794
  20.  269049
  21. (2 rows)
  22.  
  23. farsight=#  SELECT m.id
  24.             FROM sfe_rd_document AS m
  25.             ORDER BY m.email_from desc
  26.             OFFSET 0
  27.             LIMIT 3;
  28.  
  29.    id  
  30. --------
  31.  271794
  32.  269049
  33.  255599
  34. (3 rows)
  35.  
  36.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement