[ACCEPTED]-Create temporary table with fixed values-temporary

Accepted answer

Score: 12

If you only need the temp table for one 3 SQL query, then you can hard-code the data 2 into a Common Table Expression as follows 1 :

WITH temp_table AS
(
  SELECT 'Zoom' AS AC UNION
  SELECT 'Inci' UNION
  SELECT 'Fend'
)
SELECT * FROM temp_table

see it work at http://sqlfiddle.com/#!15/f88ac/2
(that CTE syntax also works with MS SQL)
HTH

Source: stackoverflow.com

More Related questions

Simple way to pass temporary struct by value in C++?

Why is it legal to borrow a temporary?

Why does calling std::string.c_str() on a function that returns a string not work?

How to pass a temporary array?

Representing Sparse Data in PostgreSQL

sql: aggregate functions & string join / concatenation

select/display last inserted serial id in postgres

Are there any restrictions on Postgres column alias names?

Postgres: order data by part of string

CASE vs Multiple UPDATE queries for large data sets - Performance

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.