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.

Mar 21 '19

Fewer Dashboards, More Analysis

#data #analytics #sql #bi

5 min read

Transposit

Mar 15 '19

The Life Changing Magic of Migrating Github repositories with Transposit

#softwaredevelopment #github #sql #api

4 min read

Transposit

Mar 7 '19

SQL order from API chaos

#serverless #javascript #api #sql

3 min read

Feb 28 '19

Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

#data #beginners #sql #bi

6 min read

Jan 8 '19

Oracle and SQLite compiler are now available in SqlKata

#sql #sqlite #oracle #c

1 min read

jreighley

Oct 6 '18

Dynamic SQL cheatsheet

#sql #ibmi #clojure

2 min read

Oct 14 '15

Check if temp table exists in SQL

#sql

1 min read

randysims

Aug 28 '18

SQL Server 2016’s STRING_SPLIT

#sqlserver #functions #sqlserver2016 #sql

1 min read

Jun 18 '18

Implementing Soft-Delete in pure MySQL

#programming #database #sql #softdelete

3 min read

Devart Software

May 17 '18

More Secure and Productive Database and Code Development in Updated SQL Complete

#sql #ssms #addin #database

1 min read

Mary Thengvall for Nylas

Feb 8 '18

Nylas is Hiring a Senior Software Engineer

#hiring #python #sql #womenintech

2 min read

randysims

Sep 12 '18

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

#sqlserver #sets #sql

1 min read

Christine Spang for Nylas

Nov 22 '17

Nylas is Hiring a Senior Software Engineer

#hiring #python #sql #womenintech

2 min read

Mar 27 '14

Check if type exists in MSSQL

#sql #mssql #snippet

1 min read

Feb 18 '14

Find column from all tables

#sql

1 min read

Jan 31 '13

Connecting to SQL over TCP/IP with Entity Framework

#entityframework #csharp #sql

1 min read

Matt Davis

Nov 5 '18

PostgreSQL: Efficient Queries - Indexing

#postgres #sql #tutorial

1 min read

Nov 22 '11

MySQL Global Vars wait_timeout & max_connections

#sql

1 min read

Jan 20 '11

MySql Version "Correlated Sub-Queries and Group By Unions"

#sql

1 min read

Jan 6 '11

SQL Correlated Sub-Queries and Group By Unions

#sql

2 min read

Jan 1 '11

SQL Get most recent records with group by

#sql

2 min read

Oct 14 '10

SQL INSERT with WHERE clause

#sql

1 min read

Sep 12 '10

Sql threesomes.. Two foreign keys, one primary key

#sql

2 min read

Jul 11 '20

SOS! Need to make a step tracking app as my first task at work.

#reactnative #sql #computerscience #android

1 min read

Jun 24 '20

Connect ReactJs to MySql

#react #sql #java

1 min read

loading...