COS

From SQLZOO
Revision as of 14:42, 16 July 2012 by Connor (Talk | contribs)

Jump to: navigation, search
Compatibility
COS(a)
EngineOKAlternative
ingresYes
mysqlYes
oracleYes
postgresYes
sqlserverYes

COS

COS(f) returns the cosine of f where f is in radians.

  COS(3.14159/3) -> 0.5 
schema:scott
 DROP TABLE angle
 CREATE TABLE angle(
  id INTEGER,
  angle FLOAT);
INSERT INTO angle VALUES (0,1);
INSERT INTO angle VALUES (1,0.7853);
INSERT INTO angle VALUES (2,0.5235);
INSERT INTO angle VALUES (3,1.0471);

In this example you return the cosine of each of the angles.

SELECT id, angle, COS(angle)
FROM scott.angle
SELECT id, angle, COS(angle)
FROM angle

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense