How to use a calculated column by another calculated column

by

You need to use a sub-query.

SELECT c.d AS a, c.d + 2 AS b
FROM
  (SELECT 1+1 AS d) c

Result

| a | b |
---------
| 2 | 4 |

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. SQLite – UPSERT *not* INSERT or REPLACE
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. Update table values from another table with the same user name
  5. SQL Select between dates
  6. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  7. What are valid table names in SQLite?
  8. How do I dump the data of some SQLite3 tables?
  9. FULL OUTER JOIN with SQLite
  10. SQLite – How do you join tables from different databases?
  11. Delete column from SQLite table
  12. sqlite database default time value ‘now’
  13. SQLite – ORDER BY RAND()
  14. Query to get records based on Radius in SQLite?
  15. How to use SQL Order By statement to sort results case insensitive?
  16. Select random row(s) in SQLite
  17. basic recursive query on sqlite3?
  18. sqlite alter table add MULTIPLE columns in a single statement
  19. Drop all tables command
  20. SQLite auto-increment non-primary key field
  21. Get month from DATETIME in sqlite
  22. How do I import .sql files into SQLite 3?
  23. sqlite equivalent of row_number() over ( partition by …?
  24. How to create timestamp column with default value ‘now’?
  25. String concatenation does not work in SQLite
  26. Unfindable SQLite Syntax Error
  27. SQLite3 UNIQUE constraint failed error
  28. Does SQLite3 have prepared statements in Node.js?
  29. SQL error: misuse of aggregate
  30. SQLite query, ‘LIKE’

Leave a Comment