Q Search ERIES 23.07.2021-A3-12AB Immersive SQL CREATE TABLE WITH THE FOLLOWING FIELDS - roll number, first name, last name, class (value should be in string like first, second), section, age. 1....


Q Search<br>ERIES<br>23.07.2021-A3-12AB<br>Immersive<br>SQL<br>CREATE TABLE WITH THE FOLLOWING FIELDS -<br>roll number, first name, last name, class (value<br>should be in string like first, second), section, age.<br>1. Write an SQL query to fetch . 2. Write an SQL query to fetch "first name" from student table in upper case. 3. Write an SQL query to fetch unique values of "CLASS" from student table. 4. Write an SQL query to find the position of the alphabet ("i") in the first name column "selvi" from student table. 5. Write an SQL query to print the "first name" from student table after removing white spaces from the right side. 6. Write an SQL query to print the "last name" from student table after hp MYSQL) "/>
Extracted text: Q Search ERIES 23.07.2021-A3-12AB Immersive SQL CREATE TABLE WITH THE FOLLOWING FIELDS - roll number, first name, last name, class (value should be in string like first, second), section, age. 1. Write an SQL query to fetch "first name" from student table using the alias name as . 2. Write an SQL query to fetch "first name" from student table in upper case. 3. Write an SQL query to fetch unique values of "CLASS" from student table. 4. Write an SQL query to find the position of the alphabet ("i") in the first name column "selvi" from student table. 5. Write an SQL query to print the "first name" from student table after removing white spaces from the right side. 6. Write an SQL query to print the "last name" from student table after hp MYSQL)

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here