Question

write the sql queries for the following.
i)write an sql query to find out the remainder of 11 divided by 4 and display 3^2
ii)write an sql query to display current date and time
iii)write an sql query to extract a substring from string "quadratically" which should be 6 characters long and starts from 5th character of the given string

Answer 1

Shruti wants to retrieve all the fields from employee table. Write SQL query to do the same.