{"id":21821,"date":"2018-08-08T04:00:42","date_gmt":"2018-08-08T04:00:42","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=21821"},"modified":"2021-03-10T14:01:57","modified_gmt":"2021-03-10T08:31:57","slug":"sql-expressions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sql-expressions\/","title":{"rendered":"SQL Expressions with Syntax and Examples"},"content":{"rendered":"

We have seen that getting correct data from the database could be problematic sometimes. To avoid and overcome these problems, we prefer to use SQL Expressions.<\/p>\n

Expressions are like formulas written within SQL queries. These are used widely for performing mathematical operations on the data stored in our database. We will dive deep into expressions in this tutorial.<\/p>\n

What are SQL Expressions?<\/h3>\n

SQL Expressions are formulas written within SQL queries to perform mathematical operations on the data we have stored in our database.<\/p>\n

We have various classifications in SQL expressions as well.<\/p>\n

Some of the prominent expressions are numerical and boolean type expressions.<\/p>\n

Types of SQL Expressions<\/h3>\n

SQL expressions are classified into three major divisions, and they are as follows:
\n1. Numeric Expressions
\n2. Boolean Expressions
\n3. Date Expressions<\/p>\n

Demo Database<\/h4>\n

We will be using a database of DataFlair Employees, which contains all the basic details of each employee.<\/p>\n

Let us first view our database:
\nQuery: SELECT * FROM DataFlair_Employee ;<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

\"SQL<\/a><\/p>\n

1. SQL Numeric Expressions<\/h4>\n

We use numerical expressions to perform mathematical operations on the stored data.<\/p>\n

Syntax: <\/strong><\/p>\n

SELECT * FROM tableName WHERE condition or expression ;<\/strong><\/p>\n

Example 1: Let us first find employees whose age, if doubled, will be more than 50.
\nQuery: SELECT * FROM dataflair_employee WHERE age*2 > 50 ;<\/strong><\/p>\n

\"SQL<\/a><\/p>\n

Here we can see the employees whose age would be more than 50 if doubled is displayed.<\/p>\n

2. SQL Boolean Expressions<\/h4>\n

SQL Boolean expressions fetch data based on one-to-one matching. In other words, we can think of it as a query that fetches one result at a time.<\/p>\n

Syntax: <\/strong><\/p>\n

SELECT * FROM tableName WHERE boolean condition ;<\/strong><\/p>\n

Example 1: Let us find out employees whose age is equal to 26.
\nQuery: SELECT * FROM dataflair_employee WHERE age = 26 ;<\/strong><\/p>\n

\"SQL<\/a><\/p>\n

Here, in the output, we can see the details of the employee with age 26.<\/p>\n

3. SQL Date Expressions<\/h4>\n

SQL date expressions are used to compare and get data according to various date-related queries and conditions.<\/p>\n

Syntax: <\/strong><\/p>\n

SELECT * FROM tableName WHERE date condition ;<\/strong><\/p>\n

Example 1: Let us find the employees who were born after 1995 January.
\nQuery: SELECT * FROM dataflair_employee WHERE DoB > DATE(‘1995\/01\/01’) ;<\/strong><\/p>\n

\"SQL<\/a><\/p>\n

In our output, we can see the details of all the employees born after January 1995.<\/p>\n

Summary<\/h3>\n

Here, we have discussed SQL expressions and their types. Expressions can be used to get the data we require using the query and needed by the user.<\/p>\n

When we use SQL expressions, they can be grouped into various types like Numerical, Boolean, and Date type.<\/p>\n

After studying these, we can easily obtain data by writing and executing better SQL queries to retrieve data.<\/p>\n","protected":false},"excerpt":{"rendered":"

We have seen that getting correct data from the database could be problematic sometimes. To avoid and overcome these problems, we prefer to use SQL Expressions. Expressions are like formulas written within SQL queries....<\/p>\n","protected":false},"author":6,"featured_media":86794,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[2869,3568,4496,6936,9168,13458,13589,15114,15115],"class_list":["post-21821","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-conditional-sql-value-expressions","tag-datetime-sql-value-expressions","tag-expressions-in-sql-server","tag-interval-sql-value-expressions","tag-numeric-value-expressions-in-sql","tag-sql-expressions-example","tag-sql-value-expressions","tag-types-of-sql-expressions","tag-types-of-sql-value-expressions"],"yoast_head":"\nSQL Expressions with Syntax and Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn what are SQL expressions and types like Numeric expression, Boolean expression and Date Expression with syntax and examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sql-expressions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Expressions with Syntax and Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn what are SQL expressions and types like Numeric expression, Boolean expression and Date Expression with syntax and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sql-expressions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-08T04:00:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T08:31:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Expressions with Syntax and Examples - DataFlair","description":"Learn what are SQL expressions and types like Numeric expression, Boolean expression and Date Expression with syntax and examples.","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:\/\/data-flair.training\/blogs\/sql-expressions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Expressions with Syntax and Examples - DataFlair","og_description":"Learn what are SQL expressions and types like Numeric expression, Boolean expression and Date Expression with syntax and examples.","og_url":"https:\/\/data-flair.training\/blogs\/sql-expressions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-08T04:00:42+00:00","article_modified_time":"2021-03-10T08:31:57+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SQL Expressions with Syntax and Examples","datePublished":"2018-08-08T04:00:42+00:00","dateModified":"2021-03-10T08:31:57+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/"},"wordCount":421,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg","keywords":["conditional sql value expressions","datetime sql value expressions","expressions in SQL server","interval sql value expressions","numeric value expressions in SQL","SQL expressions Example","SQL Value Expressions","types of SQL Expressions","Types of SQL value expressions"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sql-expressions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/","url":"https:\/\/data-flair.training\/blogs\/sql-expressions\/","name":"SQL Expressions with Syntax and Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg","datePublished":"2018-08-08T04:00:42+00:00","dateModified":"2021-03-10T08:31:57+00:00","description":"Learn what are SQL expressions and types like Numeric expression, Boolean expression and Date Expression with syntax and examples.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sql-expressions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Expressions.jpg","width":1200,"height":628,"caption":"Types of SQL Expressions"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sql-expressions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Searching for Groups of Scala Regex","item":"https:\/\/data-flair.training\/blogs\/tag\/searching-for-groups-of-scala-regex\/"},{"@type":"ListItem","position":3,"name":"SQL Expressions with Syntax and Examples"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=21821"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21821\/revisions"}],"predecessor-version":[{"id":86799,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21821\/revisions\/86799"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/86794"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=21821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=21821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=21821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}