Question

To display the starting position of your first name(fname) from your whole name​

Answer 1

To display the starting position of your first name(fname) from your whole name​

SQL QUERY:

SELECT first_name "Name",

LENGTH(first_name) "Length"

FROM employees

WHERE first_name LIKE 'J%'

OR first_name LIKE 'M%'

OR first_name LIKE 'A%'

ORDER BY first_name ;

• The result set can be sorted in either ascending or descending order using the ORDER BY keyword. Records are typically sorted using the ORDER BY keyword in ascending order. Use the DESC keyword to sort the records in descending order.
• The fetched data can be sorted in either ascending or descending order according to one or more columns using the SQL ORDER BY command.
• Data is sorted using ORDER BY by default in ascending order.
• The keywords DESC and ASC can be used to sort the data in descending order and ascending order, respectively.

#SPJ2