Enroll in PostgreSQL Courses
Get Started
Use Code 'DBGRP30' for 30% OffCategory
-
Join 155 other subscribers
Top Posts & Pages
Archives
-
Recent Posts
- Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug January 30, 2026
- PostgreSQL Table Rename and Views – An OID Story January 5, 2026
- PostgreSQL Partition Pruning: The Role of Function Volatility November 4, 2025
- Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly September 28, 2025
- PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations September 6, 2025
- PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease May 10, 2025
- Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson November 10, 2024
- PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood. November 2, 2024
- How to Connect to PostgreSQL Database Through AWS SSM Using pgAdmin or DBeaver. September 26, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance. September 23, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger August 31, 2024
- Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation August 27, 2024
-
Enhance your PostgreSQL skills! Master Database Development and Migration with my course. Click here to start!
Tag Archives: keep dense_rank postgres
Convert the KEEP Clause in Dense_Rank\Rank Analytical from Oracle to PostgreSQL
Analytical functions are a powerful tool for extracting insights from data. PostgreSQL supports most of the analytical functionality of Oracle, but it does not have a KEEP clause. This article will show you how to convert the KEEP clause in … Continue reading
Database and Migration Insights 