What is CBRT function in PostgreSQL?how can we simulate the same in SQL Server?

 Posted by Niladri.Biswas on 4/29/2013 | Category: PostgreSQL Interview questions | Views: 4174 | Points: 40
Answer:

CBRT function returns the cube root of a number.

e.g Select CBRT(64)

Result is : 4

In Sql Server we can achieve the same by using the POWER function where we need to apply the formula as POWER(float_expression,1/y)

e.g. SELECT POWER(64.0,1.00/3.00)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response