Write a MySQL query to display the firstname, lastname and bramch ID of all student in branch 111 or 666 in ascending order

Introduction

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.

- students

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

Result

21 December 2018 1892 Written By: Rohit

Write a MySQL query to display the firstname, lastname and bramch ID of all student in branch 111 or 666 in ascending order

Introduction

- students

Result

Related Topics

Responses

Popular Posts

Facebook

About Us

Subscribe