Write a MySQL query to get the student id, first name and admission month

Introduction

Write a MySQL query to get the student id, first name and admission month. I have used phpMyAdmin for the following Exercises.


techstudy.org

Kindle Paperwhite High Resolution Display Tablet | Rs. 9999

- students

StudentId FirstName LastName Admission_fee Admission_date Branch Branch_ID Email
1 John Smith 1000 2018-06-10 Computer Engineering 111 John
2 David Jones 1200 2018-06-20 Civil Engineering 222 david
3 Michael Johnson 900 2018-08-15 Chemical Engineering 333 Michael
4 Chris Lee 1500 2018-07-10 Electrical Engineering 111 Chris
5 Mike Brown 1600 2018-09-10 Mechanical Engineering 555 Mike
6 Lisa Smith 1800 2018-07-10 Computer Engineering 666 Lisa
7 Mary Smith 1600 2018-06-11 Computer Engineering 111 Mary
  1. SELECT studentid, firstname, MID( admission_date, 6, 2 ) AS hire_month
  2. FROM students

Result

sql server techstudy.org

     





Related Topics


Responses




Popular Posts

Facebook

Founded in 2016, Tech Study passionately delivers stylish and dynamic innovative information to programmer and technology lovers. http://www.techstudy.org/.