What Will Be The Output Of The Following Mysql Statementp Pre #1164
What will be the output of the following MySQL statement?</p> <pre><code class="language-sql"> SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’; </code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs113 MySQL.
It can also be found in
gs gs113 Nulls and Conditions and Miscellaneous - Condition Types - Quiz No.4.
What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;
Only those employees are selected whose first name and last name started with ‘F’
Only those employees are selected whose first name started with ‘F’ but last name can be starts with any other letter
Only those employees are selected whose first name and last name started with any other letter except ‘F’
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes
