Tag: sqls

Installing a new SQL Server instance is a common task for DBAs, and most of us use a simple and straightforward GUI approach.However, there are some configuration options, both during and...

PostgreSQL UNION statement is used to combine the resulting sets of 2 or more SELECT operators. It removes repetitive lines between different SELECT operators.Each SELECT statement in a UNION...

The PostgreSQL DELETE statement is used to remove one or more records from a table in PostgreSQL. DELETE statement syntax in PostgreSQL DELETE FROM tab [WHERE conds]; Parameters and arguments...

The PostgreSQL UPDATE statement is used to update existing table entries in a PostgreSQL database. The syntax for the UPDATE statement when updating a single table in PostgreSQL UPDATE...

PostgreSQL INSERT statement is used to insert one or more records into a table in PostgreSQL. The syntax for the INSERT statement The syntax for PostgreSQL INSERT statement when inserting a...

PostgreSQL HAVING statement is used in combination with GROUP BY statement to limit groups of returned strings only to those whose condition is TRUE. The syntax for the HAVING statement in...

PostgreSQL GROUP BY statement is used in the SELECT statement to collect data on several records and group results by one or more columns. The syntax for GROUP BY statement in PostgreSQL SELECT...

PostgreSQL ORDER BY statement is used to sort records in your result set. ORDER BY can only be used in the SELECT operator. The syntax for ORDER BY statement in PostgreSQL SELECT_id FROM...

PostgreSQL WHERE statement is used to filter results from SELECT, INSERT, UPDATE, or DELETE statement. The syntax for WHERE statement in PostgreSQL WHERE conds; Statement parameters and...

PostgreSQL DISTINCT statement is used to remove duplicates from the result set. DISTINCT can be used only with SELECT operators. Syntax for DISTINCT statement in PostgreSQL SELECT DISTINCT |...

PostgreSQL SELECT LIMIT statement is used to extract records from one or more tables in PostgreSQL and limit the number of records to be returned based on the Limit limit. Syntax for SELECT...

PostgreSQL SELECT statement is used to extract records from one or more tables into PostgreSQL.In its simplest form, the syntax for the SELECT statement in PostgreSQLSELECT_id FROM...

PostgreSQL trunc function returns a number truncated to a certain number of decimal places. Syntax of the trunc function in PostgreSQL trunc( number, [ decimal_places ] ) ) Parameters and...

PostgreSQL sum function returns the cumulative value of the expression. Syntax of the sum function in PostgreSQL SELECT sum(aggregate_expression_id) FROM tabs [WHERE conds];Or the syntax...

PostgreSQL round function returns a number rounded to a certain number of decimal places. Syntax of the round function in PostgreSQL round( number, [ decimal_places_id ] ) ) Parameters and...

PostgreSQL random function can be used to return a random number or a random number within a range. Syntax of the random PostgreSQL function random( ) Parameters and function arguments...