Скачать или смотреть #1 MYSQL Challenge | create database | create table | use AS | upper case | substring | concat

#Mysql #MysqlChallenges #techwithsimpleway
In this video we will know how to create database and create table in mysql.
in this video we will solve some mysql challenges as below.
1) Create Database DBMS Then Create Table WORKER.
2) Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as WORKER_NAME.
3) Write an SQL query to fetch “FIRST_NAME” from Worker table in upper case.
4) Write an SQL query to print the first three characters of FIRST_NAME from Worker table.
5) Write an SQL query to print the FIRST_NAME and LAST_NAME from Worker table into a single column COMPLETE_NAME. A space char should separate them.


here is link of video :-    • Find Nth Number Of Highest Salary in Table...  
(how to find highest N no. of salary in table)