Guest User

Untitled

a guest
Dec 15th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.90 KB | None | 0 0
  1. SELECT l.loc_id AS a,              
  2. l.LOCAL AS b                            
  3. FROM so_localizacao AS l                            
  4. WHERE  l.LOCAL LIKE '%aker%'                          
  5. ORDER  BY l.LOCAL ASC;
  6.  
  7. +----+-------------------------------------+
  8. | a  | b                                   |
  9. +----+-------------------------------------+
  10. | 40 | Aker Security Solutions - Brasília  |
  11. +----+-------------------------------------+
  12. 1 ROW IN SET (0.00 sec)
  13.  
  14. SELECT l.loc_id AS a,              
  15. l.LOCAL AS b                            
  16. FROM so_localizacao AS l                            
  17. WHERE  l.LOCAL LIKE '%dattein%'                          
  18. ORDER  BY l.LOCAL ASC;
  19.  
  20. +-----+--------------------------------+
  21. | a   | b                              |
  22. +-----+--------------------------------+
  23. | 221 |  DATTEIN & WILDNER LTDA ME |
  24. +-----+--------------------------------+
  25. 1 ROW IN SET (0.00 sec)
Add Comment
Please, Sign In to add comment