SIN - Revision history

Connor at 09:56, 16 July 2012

2012-07-16T09:56:23Z

2012-07-16T09:53:00Z

2012-07-16T09:52:23Z

2012-07-16T09:31:54Z

2012-07-16T09:20:56Z

2012-07-16T08:49:46Z

@@ Line 36: / Line 36: @@
 <ul>
    <li>[[COS |COS function]]</li>
-   <li>[[TAN function]]</li>
+   <li>[[TAN |TAN function]]</li>
 </ul>

@@ Line 37: / Line 37: @@
    <li>[[COS |COS function]]</li>
    <li>[[TAN function]]</li>
 </ul>

@@ Line 15: / Line 15: @@
    SIN(3.14159/6) -> 0.5
 </pre>
 <div class=params>schema:scott</div>
 <source lang=sql class='tidy'> DROP TABLE angle</source>
 <source lang=sql class='setup'> CREATE TABLE angle(
-  func VARCHAR(10),
+   id INTEGER,
-  angle INTEGER
+  angle FLOAT);
-   id INTEGER
+INSERT INTO angle VALUES (0,1);
-INSERT INTO angle VALUES (COS,0,1);
+INSERT INTO angle VALUES (1,0.7853);
-INSERT INTO angle VALUES (COS,45,1.732051/2);
+INSERT INTO angle VALUES (2,0.5235);
-INSERT INTO angle VALUES (COS,45,1/1.41421);
+INSERT INTO angle VALUES (3,1.0471);
-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);
 </source>
 In this example you return the sine of each of the angles.
 <source lang='sql' class='def'>
-SELECT id
+SELECT id, angle, SIN(angle)
- FROM angle
+FROM angle
-WHERE func = 'SIN'
 </source>
 </div>

@@ Line 18: / Line 18: @@
 <source lang=sql class='tidy'> DROP TABLE angle</source>
 <source lang=sql class='setup'> CREATE TABLE angle(
-   type VARCHAR(10),
+   func VARCHAR(10),
    angle INTEGER
    id INTEGER
@@ Line 43: / Line 43: @@
 SELECT id
   FROM angle
-WHERE type = 'SIN'
+WHERE func = 'SIN'
 </source>
 </div>

@@ Line 10: / Line 10: @@
 </table>
 <h1>SIN</h1>
-<p>COS(f) returns the cosine of f where f is in radians.</p>
+<p>SIN(f) returns the sine of f where f is in radians.</p>
 <p></p>
 <pre style='width:50ex'>
-   COS(3.14159/3) -> 0.5
+   SIN(3.14159/6) -> 0.5
 </pre>
 <div class='qu'>
-In this example you return the cosine of each of the angles.
+In this example you return the sine of each of the angles.
 <source lang='sql' class='def'>
 SELECT id,
-        COS(th)
+        SIN(th)
    FROM angle
 </source>
@@ Line 27: / Line 27: @@
 <p>See also</p>
 <ul>
-   <li>[[SIN function]]</li>
+   <li>[[COS |COS function]]</li>
    <li>[[TAN function]]</li>
    <li>[[ATAN function]]</li>
 </ul>