Learn about some best practices for working with SQL! This post is back by popular demand -- we all use SQL in our Retool apps fairly often. Example SQL snippets to use for the various SQL resource types can be super useful to have on hand. Use arrays in queries Every SQL database has a slightly di…

SQL Cheatsheet - best practices for different flavors of SQL syntax

Tess Split this topic June 25, 2024, 9:41pm 6

A post was split to a new topic: "IN" clause with Apache Hive HQL

Topic		Replies	Views
Multi-Select fails with redshift queries prepared statements 💬 Queries and Resources	15	5068	July 27, 2023
Multiselect value in snowflake query doesn't work 💬 Queries and Resources	6	2218	August 1, 2023
Show all data when a filter is not in use + Use arrays in queries 💬 App Building sql , table	2	843	June 10, 2024
How to create a dynamic query without changing resource settings? 💬 Queries and Resources sql	10	6987	August 3, 2023
Data Filters in Apps - dropdown/date filter in an App 💬 App Building	17	101	November 22, 2024