How to return only Date from SQL Server DateTime?
Overview of SQL DateTime datatype SQL Server supports four date type datatypes DATE ,DATETIME ,SMALLDATETIME ,TIMESTAMP. DATETIME datatype stores value ... Read More
Falguni Thakker
How to combine rows into one string in SQL [SOLVED]
![How to combine rows into one string in SQL [SOLVED]](https://www.golinuxcloud.com/wp-content/uploads/sql_combine_rows_into_one_string-300x169.jpg "How to combine rows into one string in SQL [SOLVED]")
SQL table can have more than one string-type column and a table can have multiple rows containing values in string-type ... Read More
Select duplicate records in SQL table [SOLVED]
Overview of SQL duplicate rows To prevent duplicate values from being inserted into a column of a database table, SQL ... Read More
How to import SQL file using CLI in MySQL?
What is an SQL file? A SQL file is one that contains SQL (Structured Query Language) statements and has the ... Read More
SQL add column with default value to an existing table [SOLVED]
![SQL add column with default value to an existing table [SOLVED]](https://www.golinuxcloud.com/wp-content/uploads/sql_add-column_with_default_value-300x169.jpg "SQL add column with default value to an existing table [SOLVED]")
Overview of default value constraints in SQL SQL default constraint is specified at the time of table creation or can ... Read More
SQL UPDATE from SELECT statement [SOLVED]
Overview of SQL UPDATE from SELECT SQL update statement is used to alter existing values in a record or in ... Read More
SQL Remove Characters from String with Examples [SOLVED]
![SQL Remove Characters from String with Examples [SOLVED]](https://www.golinuxcloud.com/wp-content/uploads/sql_remove_char_from_string-300x169.jpg "SQL Remove Characters from String with Examples [SOLVED]")
SQL specifies strings by enclosing them in single quotes for example ‘SQL tutorial’, SQL permits a variety of functions on ... Read More
SQL Delete Duplicate Rows with Practical Examples
Overview of SQL Delete duplicate rows Technically in SQL to prevent the insertion of duplicate values in a column of ... Read More
SQL Drop Constraint Explained [Practical Examples]
![SQL Drop Constraint Explained [Practical Examples]](https://www.golinuxcloud.com/wp-content/uploads/sql_drop_constraints-300x169.jpg "SQL Drop Constraint Explained [Practical Examples]")
Overview of SQL Drop Constraint SQL constraints are the restriction enforced on single or multiple columns of a table to ... Read More
SQL Floor() function Explained [Practical Examples]
![SQL Floor() function Explained [Practical Examples]](https://www.golinuxcloud.com/wp-content/uploads/sql_floor-300x169.jpg "SQL Floor() function Explained [Practical Examples]")
Overview of SQL Floor() Function SQL Floor() function is used to calculate the largest integer value that is smaller than ... Read More
Solved: SQL ambiguous column name [100% Working]
![Solved: SQL ambiguous column name [100% Working]](https://www.golinuxcloud.com/wp-content/uploads/sql_ambigious-300x169.jpg "Solved: SQL ambiguous column name [100% Working]")
What is an ambiguous column name error in SQL? SQL ambiguous column name is one most common error we are ... Read More
SQL Mapping Carnality Explained with Examples
Overview of SQL Mapping Cardinality SQL Cardinality refers to the uniqueness in the data value of a particular column, the ... Read More
SQL Ranking Functions Explained [Practical Examples]
![SQL Ranking Functions Explained [Practical Examples]](https://www.golinuxcloud.com/wp-content/uploads/sql_ranking_function-300x169.jpg "SQL Ranking Functions Explained [Practical Examples]")
Overview of SQL Ranking Functions SQL Ranking functions are window functions used to assign the ranking value for each record ... Read More
SQL Stored Procedure Explained [Practical Examples]
![SQL Stored Procedure Explained [Practical Examples]](https://www.golinuxcloud.com/wp-content/uploads/sql_stored_procedure-300x169.jpg "SQL Stored Procedure Explained [Practical Examples]")
Overview of SQL Stored Procedure SQL stored procedures are generally precompiled group of an ordered series of Transact-SQL statements stored ... Read More
35+ SQL Functions Explained in Detail [Practical Examples]
![40+ SQL Functions Explained in Detail [Practical Examples]](https://www.golinuxcloud.com/wp-content/uploads/sql_functions-300x169.jpg "35+ SQL Functions Explained in Detail [Practical Examples]")
Overview of SQL Functions SQL provides much in-build function to perform operation of table data, these functions can be with-in ... Read More