SQL Assignment 5

##mssqlserver ##sql

Chander Shekhar Jul 21 2021 · 1 min read
Share this

Task 1. Write an SQL query to print details of workers excluding first names, “Vipul” and “Satish” from Worker table.

Solution :

Task 2. Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.

Solution : 

Task 3. Write a query to validate Email of Employee.

Solution : SELECT * FROM WORKER WHERE Email_Id LIKE '%@gmail.com' or Email_Id LIKE '%@yahoo.com'

Comments
Read next