A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
Category: PostgreSQL
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Naming Conventions in SQL
Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
List tables in PostgreSQL
Unlike MySQL, Apache Hive, and Apache Impala, we can’t acquire a list of tables in PostgreSQL using the SHOW TABLES command. Use the below command
PostgreSQL – Grant Permission on Database
After a long time, when I tried to create a user and grant him all permissions on a certain database using- GRANT ALL PRIVILEGES ON
UPSERT in SQL
The UPSERT statement combines the INSERT and UPDATE statements into one statement. If another row with the identical set of primary key values already exists
Big Data and SQL 