How to use expressions in the SELECT clause in SQLite

This article will explain in detail how to use expressions in the SELECT clause in SQLite. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The SELECT clause in SQLite uses expressions

In a SELECT statement, there can be only the SELECT clause without writing the FROM clause. The list of expressions will be evaluated at one time, generate a row, and then form a worksheet. This is useful for testing and judging independent expressions. For example, the following SQL statement uses only the SELECT clause in the SELECT statement:

SELECT 1, 1, 1, 6. 68, 1, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 8, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 8, 6, 6, 6, 8, 6, 6, 6, 8

Run the program, and the execution effect is shown in figure 3.7.

Figure 3.7 running effect

This is the end of this article on "how to use expressions in SELECT clauses in SQLite". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.