Forem

select * from SQL

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

Posts

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

Conditional SQL JOIN

6
Comments 1
2 min read
ADD_MONTHS and TRUNC for calculating dates in Oracle PL/SQL
Cover image for ADD_MONTHS and TRUNC for calculating dates in Oracle PL/SQL

ADD_MONTHS and TRUNC for calculating dates in Oracle PL/SQL

1
Comments
1 min read
Sqlite db for Android

Sqlite db for Android

2
Comments
1 min read
Things I learnt today

Things I learnt today

21
Comments
1 min read
A Guide to Indexes in Oracle

A Guide to Indexes in Oracle

32
Comments 1
6 min read
SQL Tutorial Library from Career Karma
Cover image for SQL Tutorial Library from Career Karma

SQL Tutorial Library from Career Karma

9
Comments
3 min read
Building Solid Fundations on Rails Associations
Cover image for Building Solid Fundations on Rails Associations

Building Solid Fundations on Rails Associations

8
Comments 1
3 min read
Subtle issues with ORMs, and how to avoid them

Subtle issues with ORMs, and how to avoid them

15
Comments 4
8 min read
NoSQL Document Stores
Cover image for NoSQL Document Stores

NoSQL Document Stores

50
Comments 2
4 min read
Unit Test em Stored Procedures (SQL Server) Parte II
Cover image for Unit Test em Stored Procedures (SQL Server) Parte II

Unit Test em Stored Procedures (SQL Server) Parte II

3
Comments
3 min read
Can anyone help me out with SQL Server tips and tricks?

Can anyone help me out with SQL Server tips and tricks?

3
Comments 2
1 min read
I wrote a simple trivia hosting platform

I wrote a simple trivia hosting platform

2
Comments 2
1 min read
Buildmystring.com - Generate your string concatenation code

Buildmystring.com - Generate your string concatenation code

6
Comments
2 min read
Daily Commit Counts as a Terminal Graph w/ Emojis 🚀
Cover image for Daily Commit Counts as a Terminal Graph w/ Emojis 🚀

Daily Commit Counts as a Terminal Graph w/ Emojis 🚀

6
Comments
2 min read
Apply Reference table to the Rails STI type/Polymorphic type/enum/inclusion validated columns

Apply Reference table to the Rails STI type/Polymorphic type/enum/inclusion validated columns

5
Comments
4 min read
What do you use for full-text search these days?

What do you use for full-text search these days?

9
Comments 11
1 min read
Gerando um totalizador acumulado por linha sem usar cursor.
Cover image for Gerando um totalizador acumulado por linha sem usar cursor.

Gerando um totalizador acumulado por linha sem usar cursor.

3
Comments
2 min read
Selecting an Application Database
Cover image for Selecting an Application Database

Selecting an Application Database

21
Comments 8
4 min read
The What and Why of PostgreSQL Views 00:00

The What and Why of PostgreSQL Views

37
Comments 8
1 min read
QPP - My final thesis - first part

QPP - My final thesis - first part

2
Comments
2 min read
What I read this week?
Cover image for What I read this week?

What I read this week?

7
Comments
1 min read
Bitmasks in SQL

Bitmasks in SQL

10
Comments
1 min read
Corona Virus Cases Reporting

Corona Virus Cases Reporting

2
Comments
1 min read
Dirty Dynamic SQL

Dirty Dynamic SQL

10
Comments
2 min read
Defensive coding in SQL

Defensive coding in SQL

11
Comments 1
1 min read
loading...