Question

How to select all record of emp table where second letter of country is o and ends with on?

Answer 1

Answer:

select * from emp

where name like _%o____%on;

plzzzz mark brainleast

Answer 2

Select * FROM emp Where Country LIKE '_o%on';

Explanation:

• The above query gives all the records of that field which match the above where condition which says that the second letter of the column of the country is 'o' and it must end in the character 'on'.
• It is because the like operator takes one formula and match that formula with the string and the above formula which is written in like wants to combine only that string, which have 'o' on the place of second letter and it must end with the character 'on'.
• It is because '_' specify one letter previous of 'o' and '%' specify many letters before the character 'on'.

Learn More:

• SQL : https://brainly.in/question/12372046