{"id":1022,"date":"2016-07-20T03:23:10","date_gmt":"2016-07-20T03:23:10","guid":{"rendered":"https:\/\/sqltutorial.org\/?page_id=1022"},"modified":"2025-03-16T23:20:46","modified_gmt":"2025-03-17T06:20:46","slug":"sql-sin","status":"publish","type":"page","link":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/","title":{"rendered":"SQL SIN Function"},"content":{"rendered":"\n<p>In SQL, the <code>SIN\u00a0<\/code>function calculates the sine of an input argument.<\/p>\n\n\n\n<p>In math, given the ABC triangle, the sine of an angle (A) is defined as the ratio between the length of the side that is opposite that angle (a) (which is not the hypotenuse) to the length of the hypotenuse (h):<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">sin A = a \/ h<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"306\" src=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png\" alt=\"SQL_trigonometry_triangle\" class=\"wp-image-1013\" title=\"SQL SIN Function Example\" srcset=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png 292w, https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle-286x300.png 286w\" sizes=\"auto, (max-width: 292px) 100vw, 292px\" \/><\/figure>\n\n\n\n<p>For the inverse of the <code>SIN<\/code>&nbsp;function, see the <a class=\"icon-more\" href=\"https:\/\/www.sqltutorial.org\/sql-functions\/sql-asin\/\"><code>ASIN<\/code><\/a>&nbsp;function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='syntax'>Syntax <a href=\"#syntax\" class=\"anchor\" id=\"syntax\" title=\"Anchor for Syntax\">#<\/a><\/h2>\n\n\n\n<p>The following illustrates the syntax of the <code>SIN&nbsp;<\/code>function.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">SIN(numeric_expression)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\" id='argument'>Argument <a href=\"#argument\" class=\"anchor\" id=\"argument\" title=\"Anchor for Argument\">#<\/a><\/h2>\n\n\n\n<p>The <code>SIN<\/code> function accepts a <code>numeric_expression<\/code> that represents the angle in radians for which the sine is calculated.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='return-type'>Return Type <a href=\"#return-type\" class=\"anchor\" id=\"return-type\" title=\"Anchor for Return Type\">#<\/a><\/h2>\n\n\n\n<p>The <code>SIN&nbsp;<\/code>function returns a floating-point number.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='examples'>Examples <a href=\"#examples\" class=\"anchor\" id=\"examples\" title=\"Anchor for Examples\">#<\/a><\/h2>\n\n\n\n<p>The following statement returns the sine values of &nbsp;\u03c0,\/2 and \u03c0\/6.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">SIN<\/span>(<span class=\"hljs-keyword\">PI<\/span>()\/<span class=\"hljs-number\">2<\/span>) sin_half_pi, \n       <span class=\"hljs-keyword\">SIN<\/span>(<span class=\"hljs-keyword\">PI<\/span>()\/<span class=\"hljs-number\">6<\/span>) sin_one_sixth_pi;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">sin_half_pi | sin_one_sixth_pi\n------------+------------------\n          1 |              0.5\n(1 row)<\/code><\/span><\/pre>\n\n\n<p>Note that we use the&nbsp;<code>PI<\/code> function to get the \u03c0 constant.<\/p>\n\n\n\n<p>Most database systems support the <code>SIN&nbsp;<\/code>function with the same behavior.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"1022\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\"\n\t\t\t\tdata-post-title=\"SQL SIN Function\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"1022\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\"\n\t\t\t\tdata-post-title=\"SQL SIN Function\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In SQL, the SIN\u00a0function calculates the sine of an input argument. In math, given the ABC triangle, the sine of an angle (A) is defined as the ratio between the length of the side that is opposite that angle (a) (which is not the hypotenuse) to the length of the hypotenuse (h): For the inverse [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1083,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1022","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL SIN Function<\/title>\n<meta name=\"description\" content=\"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL SIN Function\" \/>\n<meta property=\"og:description\" content=\"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-17T06:20:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"292\" \/>\n\t<meta property=\"og:image:height\" content=\"306\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\",\"url\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\",\"name\":\"SQL SIN Function\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltutorial.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png\",\"datePublished\":\"2016-07-20T03:23:10+00:00\",\"dateModified\":\"2025-03-17T06:20:46+00:00\",\"description\":\"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage\",\"url\":\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png\",\"contentUrl\":\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png\",\"width\":292,\"height\":306},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltutorial.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Math Functions\",\"item\":\"https:\/\/www.sqltutorial.org\/sql-math-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL SIN Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltutorial.org\/#website\",\"url\":\"https:\/\/www.sqltutorial.org\/\",\"name\":\"SQL Tutorial\",\"description\":\"An Interactive SQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltutorial.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL SIN Function","description":"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/","og_locale":"en_US","og_type":"article","og_title":"SQL SIN Function","og_description":"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.","og_url":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/","og_site_name":"SQL Tutorial","article_modified_time":"2025-03-17T06:20:46+00:00","og_image":[{"width":292,"height":306,"url":"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/","url":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/","name":"SQL SIN Function","isPartOf":{"@id":"https:\/\/www.sqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage"},"image":{"@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png","datePublished":"2016-07-20T03:23:10+00:00","dateModified":"2025-03-17T06:20:46+00:00","description":"This tutorial explains the sine concept and shows you how to use the SQL SIN function to calculate the sine of an argument.","breadcrumb":{"@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#primaryimage","url":"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png","contentUrl":"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2016\/07\/SQL_trigonometry_triangle.png","width":292,"height":306},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltutorial.org\/sql-math-functions\/sql-sin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"SQL Math Functions","item":"https:\/\/www.sqltutorial.org\/sql-math-functions\/"},{"@type":"ListItem","position":3,"name":"SQL SIN Function"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltutorial.org\/#website","url":"https:\/\/www.sqltutorial.org\/","name":"SQL Tutorial","description":"An Interactive SQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/pages\/1022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/comments?post=1022"}],"version-history":[{"count":0,"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/pages\/1022\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/pages\/1083"}],"wp:attachment":[{"href":"https:\/\/www.sqltutorial.org\/wp-json\/wp\/v2\/media?parent=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}