What will be the output of the following MySQL statement SELECT...

Home

Competitive Exams

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer & Programming

Computer Fundamentals Networking SQL Database C Programming C++ Programming Java Python

Other Subjects

Commerce Management Law Political Science Psychology Agriculture

Exam Categories

SSC Exams Railway Exams All Exams

Popular Exams

SSC CGL SSC CHSL SSC MTS Railway Group D RRB ALP RRB Technician RRB Section Controller

Engineering Subjects

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry Metallurgical Engineering

Computer Fundamentals

Computer Fundamentals Networking Database SQL MySQL

Programming

C Programming C++ Programming Java Python PHP JavaScript

Advanced

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

This question belongs to MySQL MySQL Miscellaneous

MySQL Miscellaneous

?

What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE %t%f%n%;

A) All employees whose last name contain 't' in the second position B) All employees whose last name contains 'f' in the fourth position C) All employees whose last name contains 'n' in second last position D) All of the mentioned

Answer & Solution

Correct Answer: Option D

Let's discuss the solution. Join the discussion

Question posted by Examveda

Community

Join the Discussion

Join the discussion

Login to post a comment or share your explanation.

No comments yet Be the first to discuss this question.

Keep Learning

What will be the output of the following MySQL statement SELECT...

What will be the output of the following MySQL statement? SELECT * FROM employee WHERE lname LIKE %t%f%n%;

Join the Discussion

Related Questions on MySQL Miscellaneous

What will be the output of the following MySQL statement?

`SELECT * FROM employee WHERE lname LIKE %t%f%n%;`