Tableless Query for Postgres

SELECT 'Anto' as name, 12 as age
UNION SELECT 'Linda', 9
UNION SELECT 'Mike', 10
SELECT  *
FROM (values ('Anto', 12),('Linda', 9), ('Mike', 10) ) AS q (name, age)
SELECT id FROM regexp_split_to_table('1,2,3,4,5,7,8,9', ',') AS id
SELECT 1 as id, pg_sleep(10)

--

--

--

Technology to write, life to grateful. Overthinking is good, only if it has the output. Fundamental is the main concern.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

✅AURORA✅

Arc Finance Tutorial: How to Participate in the Testnet Airdrop Campaign

3.4 Version Update and notes on 3.5

Software development, shredding the gnar and other improbable ways to create meaning in life.

{UPDATE} Baseball Homerun Duels 2019 Hack Free Resources Generator

Onboarding SWE? Questions to ask in your first week

What programming language should I learn?

Introduction to Asyncio in Python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Iman Tung

Iman Tung

Technology to write, life to grateful. Overthinking is good, only if it has the output. Fundamental is the main concern.

More from Medium

ALL ABOUT EMBEDDED AND DYNAMIC SQL

Somewhat complex reporting and data analysis in MySql 8 — Part 1

SQL Trigger not populating with Table in Logic App

SQL and Data Science: Why is SQL important? — Part 1