Question

write a SQL query to print details of workers whose first name contains ‘ a'​

Answer 1

Answer:

Write an SQL query to print details of the Workers whose FIRST_NAME contains 'a'. Ans. The required query is: Select * from Worker where FIRST_NAME like '%a%';

Answer 2

Answer:

SQL query to print details of workers whose first name contains ‘ a'​

Select * from Workers where FIRST_NAME like '%a%';

Explanation:

• SQL(Structured Query Language) is used to query the database.
• With SQL, you can add, delete or update the data of the database.
• Here we want to print the details of the workers whose first name contains the letter 'a'.
• By containing it meant that the letter 'a' can be present anywhere in the first name.
• So first we use the SELECT command to select the workers and the * symbol shows that all the details of the selected workers will be fetched.
• After that we specify our criteria, that is first name must contain the 'a' letter.
• %a% is used to indicate that letter 'a' can be present anywhere in the first name.
• Now our query is complete, so it is terminated by putting sem-colon(;) at the end.

#SPJ3