i. To calculate the exponent for 3 raised to the power of 4. ii. To display current date and time.

Question

Write suitable SQL queries for the following:

i. To calculate the exponent for 3 raised to the power of 4.

ii. To display current date and time.

iii. To round off the value -34.4567 to 2 decimal place.

iv. To remove all the probable leading and trailing spaces from the column userid of the table named user.

v. To display the length of the string ‘FIFA World Cup’.

Answer 1

i. SELECT POWER(3,4);
ii. SELECT NOW();
iii. SELECT ROUND(-34.4567,2);
iv. SELECT TRIM(USERID) FROM USER;
v. SELECT LENGTH("FIFA World Cup");