Introduction In SQL , sometimes it is needed to use Single Quote in Strings and it comes rather confusing for new users in managing that ordeal.In this article we will focus on how can we use single quote in strings. How to escape single quote (‘) ? In SQL, if you want to use single …
Introductiuon In SQL, Creating and inserting data is important but maintaining databases are also important. Sometimes user are not happy with the current name of the table and wants to rename them according to needs. CAUTION : Before committing to any change, user should double check that renaming the table will not make or break …
Introduction In SQL , learning unpivoting of data is as important as learning pivoting of data.Sometimes we need to transform data from column to rows for efficient analysis. The UNPIVOT function is useful when you have data in a pivoted format, with values spread across multiple columns, and you want to convert it back into …
In SQL Server, You can use PIVOT to convert rows into columns. Syntax: <non-pivoted column> are columns which are not intended for pivot[pivoted column1], [pivoted column2] are columns which we want to pivotThe Select statement in FROM clause is for source table<aggregate_function> is useful when we have two or more rows with similar primary key …
Introduction In SQL, the IDENTITY property is used to create an auto-incrementing column. This property is mostly useful for generating unique numeric values. They are typically used as primary keys. The IDENTITY property is commonly associated with integer data types. Different database systems may have variations in syntax for implementing this property, for example in …
FLOOR() Function: SQL FLOOR is used to return the largest integer less than or equal to the specified numeric expression. Syntax: EXAMPLE: The result is the numeric part with the same data type. CEILING() Function: SQL CIELING() is used to get the smallest integer greater than, or equal to, the specified numeric expression as return …
ROW_NUMER() SQL ROW_NUMBER() is used to number the result set. The return type is integers. Syntax: EXAMPLE: For example purpose we will use table named ‘EMPLOYEE’. Lets use ROW_NUMBER() to number the rows. You can see a new column is created and numbers have been given according to ‘SALARY’ . We used ORDER BY clause …
SQL LIKE SQL LIKE operators are used in conjunction with WHERE clause to find patterns in the strings. Two wild card characters are used with LIKE operators-‘%’ is used to represent zero, one, or multiple character‘_’ is used when you want to represent only one character Syntax: WHERE Clause in above statement will match with …
SQL date functions are important to learn if you want to do anything related to-Forecasting.Managing historical data.There are several types of SQL Date functions but we are going to learn basics first. The Three SQL functions we are going to learn in this lesson are – DATEPART() This function returns an integer representing the specified datepart of …
SQL case are used to evaluate a set of expression and return the expression that fulfils the condition. There are two types of SQL CASE – The simple CASE expression compares an expression to a set of simple expressions to determine the result. The searched CASE expression evaluates a set of Boolean expressions to determine …
