Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
453
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. SELECT *
  2. FROM `Buses`
  3. WHERE `BusID` I am stuck after this.. how do I put in the list of 20 BusIds here?
  4.  
  5. SELECT * FROM `Buses` WHERE BusId IN (`list of busIds`)
  6.  
  7. SELECT * FROM `Buses` WHERE BusId IN (SELECT SomeId from OtherTable WHERE something = somethingElse)
  8.  
  9. SELECT * FROM `Buses` JOIN OtheTable on Buses.BusesId = OtehrTable.BusesId
  10.  
  11. SELECT * FROM `Buses` WHERE `BusID` IN (1,2,3,5,7,9,11,44,88,etc...);
  12.  
  13. id|firstname|lastname|username |password
  14. 1 |joe |doe |joe.doe@email.com |1234
  15. 2 |jane |doe |jane.doe@email.com |12345
  16. 3 |johnny |doe |johnny.doe@email.com|123456
  17.  
  18. SELECT * FROM users;
  19.  
  20. SELECT id, firstname, lastname FROM users;
  21.  
  22. SELECT * FROM users
  23. WHERE ( ( username = 'joe.doe@email.com' ) AND ( password = '1234' ) );
  24.  
  25. SELECT id FROM users
  26. WHERE ( ( username = 'joe.doe@email.com' ) AND ( password = '1234' ) );
  27.  
  28. SELECT * FROM users
  29. WHERE ( id IN (1,2,..,n) );
  30.  
  31. SELECT * FROM users
  32. WHERE ( ( id >= 20 ) AND ( id <= 40 ) );
  33.  
  34. SELECT *
  35. FROM `Buses`
  36. WHERE `BusID` IN (Id1, ID2, ID3,.... put your ids here)
  37.  
  38. SELECT *
  39. FROM `Buses`
  40. WHERE `BusID` IN (SELECT Id FROM table)
  41.  
  42. SELECT *
  43. FROM users
  44. WHERE firstname IN ('joe','jane');
  45.  
  46. SELECT person_id,
  47. (ROW_NUMBER () OVER (PARTITION BY pers_email ORDER BY pers_name) person_count
  48. from pers_table
  49. WHERE person_count > 2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement