3475 Views
HAVING is very resemble WHERE. The only dissimilarity is that WHERE filters rows and HAVING filters groups. Increase in SQL HAVING clause because the WHERE keyword can not be used with the combination of functions.
Syntax
SELECT column_name
FROM table_name
WHERE condition
GROUP BY column_name
HAVING ...
Anamika Gupta
May 17, 2022
1769 Views
The GROUP BY statement is passed down to group the rows that have the same values in the table.
Grouping allows you to divide data into logical sets so that you can perform a collection of calculations on each group. Groups are built for using the GROUP BY clause in the SELECT statement.
The GROUP ...
Anamika Gupta
May 11, 2022
1551 Views
The UNION operator is used to JOIN the result-set of two or more two selected statements.
Using UNION, multiple SELECT statements can be described, and their results can be combined into a single result set.
Each query in a UNION must include the same columns, expressions or combined ...
Anamika Gupta
May 10, 2022
1615 Views
SQL JOIN
A JOIN a clause is used to associate rows from two or more tables, placed on a similar column between them.
With the help of joins, we can recover the data from two or more tables rooted in logical relationships between the tables. Joins signalizes how the SQL Server is compelled ...
Anamika Gupta
May 03, 2022
5123 Views
When you website or product have lots of important data then you might be always worry about database backup. But taking the database backup daily is a time-taking job. Here we are providing solution for automatic MySql database backup on Monthly / Hourly / Weekly / Daily or Hourly basis.
To ...
Sheetal Kumar
Feb 16, 2019
25050 Views
When you install MySql server on ubuntu then it is not assessable from any client tool like MySql Workbench or Datagrip. To allow access in mysql to access from anywhere you need to change some configuration in MySql Server.
First of all let me tell you how to install MySql Server on Ubuntu.
Step ...
Sheetal Kumar
Feb 04, 2019
2804 Views
Set Operations
Set operations is used to merge query results by combining two or more queries into a particular single result.
SQL support three set operators which have the proper pattern.
<query 1> <set operators> <query 2>
Union
The UNION command is ...
Anamika Gupta
Aug 14, 2018
11350 Views
Rules for SQL commands
1. SQL commands can be written on multiple line.
2. Clauses are generally used to separate lines to build accuracy through it is not necessary.
3. Tabulation (Index) can be used.
4. Command words cannot divide over the lines.
5. SQL ...
Anamika Gupta
Aug 09, 2018
2619 Views
There are four types of SQL (structure query language) operator which is used to operate with all the data types. In the SQL if the attributes or data are used in the list they must be embedded in a single quote ( ' ' ).
Operator
Description
BETWEEN....AND.....
It ...
Anamika Gupta
Aug 07, 2018
3640 Views
What is SQL?
SQL is a structure Query language which is used to manage relational database and perform various operations .It is a standardized programming language working on a various queries such as INSERT,SEARCH, UPDATE, DELETE database record. It is pronounced as ...
Anamika Gupta
May 24, 2018
8778 Views
PostgreSQL is the open source relational database system. PostgreSQL has some advanced features of database like
User-defined types
Table inheritance
Sophisticated locking mechanism
Foreign key referential integrity
Views, rules, subquery
Nested transactions (savepoints)
Multi-version ...
Sheetal Kumar
Feb 13, 2018