Question

Write the SQL functions which will perform the following operations:

i) To display the name of the month of the current date .

ii) To remove spaces from the beginning and end of a string, “ Panorama “.

iii) To display the name of the day eg, Friday or Sunday from your date of birth, dob.

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

OR

Consider a table SALESMAN with the following data:

Write SQL queries using SQL functions to perform the following operations:

a) Display salesman name and bonus after rounding off to zero decimal places.

b) Display the position of occurrence of the string “ta” in salesman names.

c) Display the four characters from salesman name starting from second character.

d) Display the month name for the date of join of salesman

Answer 1

i) monthname(date(now()))

ii) trim(“ Panaroma “)

iii) dayname(date(dob))

iv) instr(name, fname)

OR

i) Select sname, round(bonus,0) from Salesman;

ii) Select instr(Sname, “ta”) from Salesman;

iii) Select mid(Sname,2,4) from Salesman;

iv) Select monthname(DateofJoin) from Salesman;