検索
検索

Add row to Firebird query result using select

debugcn 投稿 Dev
8
zokanzi

Is it possible to extend query results with literals like this?

SELECT  name, city, age
FROM    users
UNION
SELECT  'John' as name, 'Amsterdam' as city, 20 as age
Marcodor

from clause is mandatory in Firebird, so write from rdb$database.

rdb$database is a system table that has only a single row.

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0
サインイン

関連記事

分類Dev

Add row to a select query

分類Dev

Select first row from group each by with count using Big Query

分類Dev

Select statement only returning first row in result

分類Dev

Using select result to replace string

分類Dev

Looping result from SQL select query

分類Dev

store result of select query into array variable

分類Dev

SELECT query return error on Empty result

分類Dev

postgres SELECT query returns unusable result

分類Dev

SELECT query that Selects from Next Row given certain criteria using SQL Server 2008 R2?

分類Dev

I need to add a tinyint value in the result of a SELECT

分類Dev

SELECT query to print as JSON list in one row

分類Dev

Inserting text into SQL SELECT query row

分類Dev

Add extra row from distinct in select

分類Dev

How to add totals row to excel power query?

分類Dev

using arrays to query with SELECT with PHP

分類Dev

using PDO object for a Select query

分類Dev

sql query to select a random row from a table based on the previous query

分類Dev

MySQL get just one row duplicated result on select

分類Dev

Using the result of a 'previous' column in a SELECT statement

分類Dev

Using the result of a select clause for a where clause to MySQL

分類Dev

SQL Query ,How to show result in row wise format?

分類Dev

MySQL: Select query execution and result fetch time increases with number of connections

分類Dev

Query with broken sub-select should result in error but returns rows

分類Dev

Loop the select query result set in MYSQL Stored Procedure

分類Dev

How to add an additional fake null column to select result in Informix?

分類Dev

Add extra rows in result set of query with dummy data in sql server

分類Dev

Add result set of an sql query to email Body in Powershell

分類Dev

Why is the result of datediff year in Firebird too high?

分類Dev

Select last row using ROW_NUMBER function

Related 関連記事

  1. 1

    Add row to a select query

  2. 2

    Select first row from group each by with count using Big Query

  3. 3

    Select statement only returning first row in result

  4. 4

    Using select result to replace string

  5. 5

    Looping result from SQL select query

  6. 6

    store result of select query into array variable

  7. 7

    SELECT query return error on Empty result

  8. 8

    postgres SELECT query returns unusable result

  9. 9

    SELECT query that Selects from Next Row given certain criteria using SQL Server 2008 R2?

  10. 10

    I need to add a tinyint value in the result of a SELECT

  11. 11

    SELECT query to print as JSON list in one row

  12. 12

    Inserting text into SQL SELECT query row

  13. 13

    Add extra row from distinct in select

  14. 14

    How to add totals row to excel power query?

  15. 15

    using arrays to query with SELECT with PHP

  16. 16

    using PDO object for a Select query

  17. 17

    sql query to select a random row from a table based on the previous query

  18. 18

    MySQL get just one row duplicated result on select

  19. 19

    Using the result of a 'previous' column in a SELECT statement

  20. 20

    Using the result of a select clause for a where clause to MySQL

  21. 21

    SQL Query ,How to show result in row wise format?

  22. 22

    MySQL: Select query execution and result fetch time increases with number of connections

  23. 23

    Query with broken sub-select should result in error but returns rows

  24. 24

    Loop the select query result set in MYSQL Stored Procedure

  25. 25

    How to add an additional fake null column to select result in Informix?

  26. 26

    Add extra rows in result set of query with dummy data in sql server

  27. 27

    Add result set of an sql query to email Body in Powershell

  28. 28

    Why is the result of datediff year in Firebird too high?

  29. 29

    Select last row using ROW_NUMBER function

ホットタグ

アーカイブ