Featured
-
Find out a particular column throughout the database in Postgresql
Previously got a situation where I needed to get t
by Nitika.Verma
Tags
INTERSECT Clause
INTERSECT Clause:
It works similar like union clause as it is used to combine two SELECT statements, but it returns tuples only from first SELECT statement which are common to tuples in the second SELECT statement.
Syntax:
S...
SQL: How to display all the records related to common id
I was stuck in the following issue. Issue was related with retrieving common records in group. I have to display records which are common with each id.
Following records are inserted into the table "mytable":
id | ti...
What is process to Copy entire date into other table in SQL Database ?
Hi Reader's,
Welcome to FindNerd, today we are going to discuss what is process to Copy entire date into other table in SQL Database ?
If you want to copy a SQL table into another table in the same SQL database then you should use copy st...
Use of AVG() Function in MySql
The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns.
Syntax:
SELECT AVG(column-n...
TOP Clause in SQL
SELECT TOP clause:
TOP clause is used to fetch specific
number of records from a table.
This clause is very handy when we
have huge table of thousands of
record in it . And fetching data
from these tables are quite
time-consuming , in ...
How to use Right Join on two tables
Right Join:
Right Join is used to join two tables and it return all rows from right table(table 2) and matching rows from table 1(left table). The result is NULL for unmatched rows for table 1(left table). Right Join keyword is used to apply R...
SQL Tutorial -> Sql Joins
<-- Chapter 24: SQL Aliases
Chapter 25
SQL Joins
SQL Joins clause are used to combine data rows from two or more than two tables according to common field values between them.
Lets see an examples from the below tables "customer...
SQL Tutorial -> SQL Aliases
<-- Chapter 23: SQL Wildcards
Chapter 24
SQL Aliases
SQL Aliases are used to rename a particular table name or column name in a temporary manner. In a SQL statement , any table or column name can be temporary change.
SQL Syntax fo...
SQL Tutorial -> Sql Select Top
<-- Chapter 21: SQL Injection
Chapter 22
SQL Select Top
SQL Select Top clause is used to retrieve TOP N number of Records or X percent of Records from database table.
Note: All database systems does not support the SELECT TOP claus...
ALIAS Keyword
ALIAS Keyword:
It is used to give temporary names to table and columns. It is very useful for situations where column or table names are too long.
Synatx:
SELECT columnname AS alias_name FROM tablename;
This syntax is used ...
SQL Tutorial -> Sql Delete
<-- Chapter 19: SQL UPDATE
Chapter 20
SQL DELETE
DELETE statement is used to delete a particular data Rows from Database Table with the help of WHERE clause. Without WHERE clause all rows will be deleted.
Lets see an example from th...
SQL Tutorial > Sql And & Or
<-- Chapter 15: SQL <= Operator
Chapter 16
SQL And & Or
AND/OR Operators are used in SQL statements to filter the Records based on more than one condition. AND Operator display the records in which all the specified conditions a...
SQL Tutorial -> Sql > Operator
<-- Chapter 11: SQL BETWEEN Operator
Chapter 12
SQL > Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-...
SQL Tutorial -> Sql != Operator
<-- Chapter 8: SQL = Operator
Chapter 9
SQL != Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Docto...
SQL Tutorial -> Sql = Operator
<-- Chapter 7: SQL NOT IN Operator
Chapter 8
SQL = Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
D...
SQL Tutorial -> Sql NOT IN Operator
<-- Chapter 6: SQL IN Operator
Chapter 7
SQL NOT IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
...
SQL Tutorial -> Sql IN Operator
<-- Chapter 5: SQL Where
Chapter 6
SQL IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Doctor
80...
SQL Tutorial -> Sql Where
<-- Chapter 4: SQL Distinct
Chapter 5
SQL Where
SQL Where : SQL Where clause extract or filters those records which matches the specified condition. Syntax for Where clause is used below
SELECT *
FROM tablename
WHERE condition
...
SQL Tutorial -> Sql Distinct
<-- Chapter 3: SQL Select
Chapter 4
SQL District
SQL District : District is a keyword which is used to fetch unique column values from database table OR we can simply say that ignores the column duplicate values. Syntax for district ke...
SQL Tutorial -> Sql Select
<-- Chapter 2: SQL Syntax
Chapter 3
SQL Select
SQL Select :
SELECT command describes that through which we can fetch data from MYSQL database tables OR we can say, It is used to retrieve/select data from MYSQL database.
SELECT comma...
SQL Tutorial ->Introduction to SQL
Chapter 1
Introduction to SQL
Introduction to SQL : SQL stands for Structured Query Language or we can call it as "sequel" or "S-Q-L" . SQL is a query Language used to accessing and modifying information in a database.There are some common ...
SQL Tutorial -> Sql Syntax
<-- Chapter 1 Introduction to SQL
Chapter 2
SQL Syntax
SQL Syntax : SQL syntax is basically followed by sql commands which modifies the database tables such as "users" , "students" etc. All the SQL statements always starts with the key...
SQL Server Management Data Warehouse (MDW)
Management Data warehouse is a database containing a warehouse of data useful for managing SQL Server. Ensuring the excellent and high performance for all the users and customers is a high priority for Database Administrators. Troubleshooting SQL...
Compression and Decompression in SQL Server 2016
In the upcoming version of SQL 2016 a new component of COMPRESS and DECOMPRESS T-SQL functions is added. SQL Server 2016 provides built in functions for compression and decompression.The COMPRESS and DECOMPRESS functions can store and retrieve da...
