(SQL Example for Citizen Data Scientist & Business Analyst) SQL | Date functions In SQL, dates are complicated for newbies, since while working with database, the format of the date in table must be matched with the input date in order to insert. In various scenarios instead of date, datetime (time is also involved …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL Server Mathematical functions (SQRT, PI, SQUARE, ROUND, CEILING & FLOOR) Mathematical functions are present in SQL server which can be used to perform mathematical calculations. Some commonly used mathematical functions are given below: 1. SQRT(): SQRT() function is the most commonly used function. It …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | Join (Inner, Left, Right and Full Joins) A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are: INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | BETWEEN & IN Operator BETWEEN The SQL BETWEEN condition allows you to easily test if an expression is within a range of values (inclusive). The values can be text, date, or numbers. It can be used in a SELECT, INSERT, UPDATE, or DELETE …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | Except Clause In SQL, EXCEPT returns those tuples that are returned by the first SELECT operation, and not returned by the second SELECT operation. This is the same as using a subtract operator in relational algebra. Example: Say we have two relations, Students and …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | MINUS Operator The Minus Operator in SQL is used with two SELECT statements. The MINUS operator is used to subtract the result set obtained by first SELECT query from the result set obtained by second SELECT query. In simple words, we can say …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | LIKE Sometimes we may require tuples from the database which match certain patterns. For example, we may wish to retrieve all columns where the tuples start with the letter ‘y’, or start with ‘b’ and end with ‘l’, or even more complicated and …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | LIMIT Clause If there are a large number of tuples satisfying the query conditions, it might be resourceful to view only a handful of them at a time. The LIMIT clause is used to set an upper limit on the number of tuples …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | Join (Cartesian Join & Self Join) In this article, we will discuss about the remaining two JOINS: CARTESIAN JOIN SELF JOIN Consider the two tables below: StudentCourse CARTESIAN JOIN: The CARTESIAN JOIN is also known as CROSS JOIN. In a CARTESIAN JOIN …
(SQL Example for Citizen Data Scientist & Business Analyst) SQL | ALTER (ADD, DROP, MODIFY) ALTER TABLE is used to add, delete/drop or modify columns in the existing table. It is also used to add and drop various constraints on the existing table. ALTER TABLE – ADD ADD is used to add columns into …