Tech Study

Write MySQL query to display the firstname, lastname and admission date for all students who took admission in year 2016

Introduction

Write MySQL query to display the firstname, lastname and admission date for all students who took admission in year 2016. I have used phpMyAdmin for the following example.

– students

StudentId FirstName LastName Admission_fee Admission_date Branch Branch_ID
1 John Smith 1000 2016-06-10 Computer Engineering 111
2 David Jones 1200 2018-06-20 Civil Engineering 222
3 Michael Johnson 900 2016-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, admission_date
FROM students
WHERE YEAR( admission_date ) LIKE  '2016%'

Result

Write MySQL query to display the firstname, lastname and admission date for all students who took admission in year 2016
Write MySQL query to display the firstname, lastname and admission date for all students who took admission in year 2016

Taggedlastname and admission date for all students who took admission in year 2016Write MySQL query to display the firstname

Java Final keyword

Introduction : java final keyword The final keyword present in Java programming language is generally used for restricting the user. …

Read more

C++ Memory Management: new and delete

C++ Memory Management We know that arrays store contiguous and the same type of memory blocks, so memory is allocated …

Read more