Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Muhammad Muneeb Ur Rehman

May 20 '23

How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

#sql #postgres #backend #webdev

3 min read

May 18 '23

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql

4 min read

Massy

May 19 '23

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

#mysql #database #dataanalysis #sql

2 min read

Dutra

May 18 '23

SAS Function setDateByNumberBDays

#sas #sql #proc

1 min read

Dutra

May 18 '23

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc

1 min read

Dutra

May 18 '23

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc

1 min read

InterSystems Developer for InterSystems

May 18 '23

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial

5 min read

May 7 '23

MySQL Basic Select challenges

#sql #mysql

2 min read

May 18 '23

Managing Calendar Availability in Supabase with SQL generate_series

#tutorial #postgres #sql #react

3 min read

Aviator

May 18 '23

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience

6 min read

Dutra

May 17 '23

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp

1 min read

Dutra

May 18 '23

SAS Function isBusinessDay

#sas #sql #datefunctions #proc

1 min read

Franck Pachot for AWS Heroes

May 17 '23

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql

10 min read

May 16 '23

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql

2 min read

Aviator

May 14 '23

Introduction to SQL set operators

#sql #database #datascience #analytics

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.