Courses
Tutorials
Jobs
Practice
Contests
Data Structure
Java
Python
HTML
Interview Preparation
Trending Now
DSA
Web Tech
Foundational Courses
Data Science
Practice Problem
Python
Machine Learning
JavaScript
System Design
Django
DevOps Tutorial
Java
C
C++
ReactJS
NodeJS
CP Live
Aptitude
Puzzles
Projects
GBlog
Complete DevOps Roadmap - Beginner to Advanced
DevOps is considered a set of practices that combines the abilities of Software Development i.e Dev and IT Operations i.e Ops together, which results in delivering top-not...
Read More
Introduction of 5 pen PC Technology
5 pen PC technology is a computer technology in style of pen. It was developed in 2012 by a Japanese Technology Company, NEC. This technology consists of an input device w...
Read More
Computer Networks
PostgreSQL - DATE_PART Function
In PostgreSQL, the DATE_PART() function is used to query for subfields from a date or time value.Syntax: DATE_PART(field, source)In the above syntax the field is an identi...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Date-function
PostgreSQL - CURRENT_DATE Function
The PostgreSQL CURRENT_DATE function returns the current date.Syntax: CURRENT_DATEReturn value:The CURRENT_DATE function returns a DATE value that represents the current d...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Date-function
PostgreSQL - ALTER TABLESPACE
In PostgreSQL, the ALTER TABLESPACE statement is used to rename, change the owner, or set parameters for a tablespace.Syntax:ALTER TABLESPACE tablespace_nameaction;To rena...
Read More
PostgreSQL
postgreSQL-managing-table
PostgreSQL - CREATE TABLESPACE
In PostgreSQL a tablespace is used to map a logical name to a physical location on disk. In the simplest word, we can understand tablespace as a location on the disk wher...
Read More
PostgreSQL
postgreSQL-managing-table
PostgreSQL - Role Membership
In this article, we will look into PostgreSQL group roles and their uses to manage privileges in a PostgreSQL database more effectively. It is a standard practice to creat...
Read More
PostgreSQL
postgreSQL-administration
PostgreSQL - DROP ROLE
In PostgreSQL the DROP ROLE statement to remove a role.Syntax: DROP ROLE [IF EXISTS] target_role;Let's analyze the above syntax:After the DROP ROLE keywords add the role n...
Read More
PostgreSQL
postgreSQL-administration
PostgreSQL - ROW_NUMBER Function
In PostgreSQL, the ROW_NUMBER() function is used to assign a unique integer to every row that is returned by a query.Syntax:ROW_NUMBER() OVER( [PARTITION BY column_1, c...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - RANK Function
In PostgreSQL, the RANK() function is used to assign a rank to each row of the query result set within the specified partition. The rank of the first row within each part...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - CUME_DIST Function
In PostgreSQL, the CUME_DIST() function is used to query for the relative position os a value within a set of given values.Syntax:CUME_DIST() OVER ( [PARTITION BY parti...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - NTILE Function
In PostgreSQL, the NTILE() function is used to divide ordered rows in the partition into a specified number of ranked buckets. Buckets are nothing but ranked groups.The sy...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - LEAD Function
In PostgreSQL, the LEAD() function is used to access a row that follows the current row, at a specific physical offset and is generally used for comparing the value of the...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - LAST_VALUE Function
In PostgreSQL, the LAST_VALUE() function returns the last value in an ordered partition of the query result set .Syntax:LAST_VALUE ( expression ) OVER ( [PARTITION BY...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL - FIRST_VALUE Function
In PostgreSQL, the FIRST_VALUE() function is used to return the first value in a sorted partition of a result set.Syntax:FIRST_VALUE ( expression ) OVER ( [PARTITION ...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
PostgreSQL- DENSE_RANK Function
In PostgreSQL, the DENSE_RANK() function is used to assign a rank to each row within a partition of a result set, with no gaps in ranking values. The DENSE_RANK() assigns...
Read More
PostgreSQL
PostgreSQL-function
PostgreSQL-Window-function
1
...
7170
7171
7172
...
10982