Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM `Buses`
- WHERE `BusID` I am stuck after this.. how do I put in the list of 20 BusIds here?
- SELECT * FROM `Buses` WHERE BusId IN (`list of busIds`)
- SELECT * FROM `Buses` WHERE BusId IN (SELECT SomeId from OtherTable WHERE something = somethingElse)
- SELECT * FROM `Buses` JOIN OtheTable on Buses.BusesId = OtehrTable.BusesId
- SELECT * FROM `Buses` WHERE `BusID` IN (1,2,3,5,7,9,11,44,88,etc...);
- id|firstname|lastname|username |password
- 1 |joe |doe |joe.doe@email.com |1234
- 2 |jane |doe |jane.doe@email.com |12345
- 3 |johnny |doe |johnny.doe@email.com|123456
- SELECT * FROM users;
- SELECT id, firstname, lastname FROM users;
- SELECT * FROM users
- WHERE ( ( username = 'joe.doe@email.com' ) AND ( password = '1234' ) );
- SELECT id FROM users
- WHERE ( ( username = 'joe.doe@email.com' ) AND ( password = '1234' ) );
- SELECT * FROM users
- WHERE ( id IN (1,2,..,n) );
- SELECT * FROM users
- WHERE ( ( id >= 20 ) AND ( id <= 40 ) );
- SELECT *
- FROM `Buses`
- WHERE `BusID` IN (Id1, ID2, ID3,.... put your ids here)
- SELECT *
- FROM `Buses`
- WHERE `BusID` IN (SELECT Id FROM table)
- SELECT *
- FROM users
- WHERE firstname IN ('joe','jane');
- SELECT person_id,
- (ROW_NUMBER () OVER (PARTITION BY pers_email ORDER BY pers_name) person_count
- from pers_table
- WHERE person_count > 2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement