Write a MySQL query to display the firstname, lastname and bramch ID of all student in branch 111 or 666 in ascending order. I have used phpMyAdmin for the following example.
StudentId | FirstName | LastName | Admission_fee | Admission_date | Branch | Branch_ID |
---|---|---|---|---|---|---|
1 | John | Smith | 1000 | 2018-06-10 | Computer Engineering | 111 |
2 | David | Jones | 1200 | 2018-06-20 | Civil Engineering | 222 |
3 | Michael | Johnson | 900 | 2018-08-15 | Chemical Engineering | 333 |
4 | Chris | Lee | 1500 | 2018-07-10 | Electrical Engineering | 444 |
5 | Mike | Brown | 1600 | 2018-09-10 | Mechanical Engineering | 555 |
6 | Lisa | Smith | 1800 | 2018-07-10 | Computer Engineering | 666 |
7 | Mary | Smith | 1600 | 2018-06-11 | Computer Engineering | 777 |
SELECT firstname, lastname, studentid FROM students WHERE branch_id IN ( 111, 444 ) ORDER BY branch_id ASC
21 December 2018 1826 Written By: Rohit
Founded in 2016, Tech Study passionately delivers stylish and dynamic innovative information to programmer and technology lovers. http://www.techstudy.org/.
© 2018 Tech Study. All rights reserved | Developed by Tech Study| Privacy Policy | Sitemap