Difference between revisions of "SIN"
From SQLZOO
| Line 18: | Line 18: | ||
<source lang=sql class='tidy'> DROP TABLE angle</source> | <source lang=sql class='tidy'> DROP TABLE angle</source> | ||
<source lang=sql class='setup'> CREATE TABLE angle( | <source lang=sql class='setup'> CREATE TABLE angle( | ||
| − | + | func VARCHAR(10), | |
angle INTEGER | angle INTEGER | ||
id INTEGER | id INTEGER | ||
| Line 43: | Line 43: | ||
SELECT id | SELECT id | ||
FROM angle | FROM angle | ||
| − | WHERE | + | WHERE func = 'SIN' |
</source> | </source> | ||
</div> | </div> | ||
Revision as of 09:31, 16 July 2012
| SIN(s1 IN s2) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | |
| mysql | Yes | |
| oracle | Yes | |
| postgres | Yes | |
| sqlserver | Yes | |
SIN
SIN(f) returns the sine of f where f is in radians.
SIN(3.14159/6) -> 0.5
schema:scott
DROP TABLE angle
CREATE TABLE angle( func VARCHAR(10), angle INTEGER id INTEGER INSERT INTO angle VALUES (COS,0,1); INSERT INTO angle VALUES (COS,45,1.732051/2); INSERT INTO angle VALUES (COS,45,1/1.41421); INSERT INTO angle VALUES (COS,60,1/2); INSERT INTO angle VALUES (COS,90,NULL); INSERT INTO angle VALUES (SIN,0,0); INSERT INTO angle VALUES (SIN,30,1/2); INSERT INTO angle VALUES (SIN,45,1/1.41421); INSERT INTO angle VALUES (SIN,60,1.732051/2); INSERT INTO angle VALUES (SIN,90,1); INSERT INTO angle VALUES (TAN,0,0); INSERT INTO angle VALUES (TAN,30,1/1.732051); INSERT INTO angle VALUES (TAN,45,1); INSERT INTO angle VALUES (TAN,60,1.732051); INSERT INTO angle VALUES (TAN,90,1/0);
In this example you return the sine of each of the angles.
SELECT id FROM angle WHERE func = 'SIN'
See also
