How SQL displays the same field value multiple times based on a condition

Tools Material: Management Studio.

1. First, on the desktop, click on the "Management Studio" icon.

2. Secondly, in this window, click the "New Query" option in the upper left corner.

3. In this window, enter the SQL statement "select * from rss where grade=100 or grade = 90;" for one field and multiple values of the query condition”。

4. In this window, click the "Execute" button on the upper left.

5. Finally, in this window, display the query condition for one field and multiple values successfully.

Tools Material: Management Studio.

1. First copy

On the table surface, click on the "Management Studio" icon. zhi

2. Secondly, in this window, click the "DAO New Query" option in the upper left corner.

4. In this window, click the "Execute" button on the upper left.

5. Finally, in this window, display the query condition for one field and multiple values successfully.

Write as much as you want with in, remembering to separate it with a comma in between.

select * from otim where sheetid in (1,2,3,4);

You can write in(1,2,3) or query the union all query results separately.

select * from otim where sheetid = 1 or sheetid = 2 or sheetid = 3;

It's good to use or condition.

Assume that the table name is test, and the column ID is a numeric type. If you use multiple values of the same field as a condition, you can use in or or.

The specific statements are as follows:

1、select * from test where id in (1,2,3)

go2、select * from testwhere id= 1orid =2orid=3

GO Structured Query Language (SQL (pronunciation: es kju el s-q-l) is a type of programming language for special purposes, a class of database query and French imagination language, which is used to access data and query, update and manage relational database systems; It is also an extension for database script files.

Tools Material: Management Studio.

1. First, on the desktop, click on the "Management Studio" icon.

2. Secondly, in the window, click the "New Query" option in the upper left corner.

3. In this window, enter the SQL statement "select * from rss where grade=100 or grade = 90;" for multiple values of the query condition”。

4. In this window, click the "Execute" button on the upper left.

5. Finally, in this window, display the query condition for one field and multiple values successfully.

Tools Material: Management Studio.

1. First, on the desktop, click on the "Management Studio" icon.

2. Secondly, in the window, click the "New Query" option in the upper left corner.

3. In this window, enter the SQL statement "select * from rss where grade=100 or grade = 90;" for multiple values of the query condition”。

4. In this window, click the "Execute" button on the upper left.

5. Finally, in this window, display the query condition for one field and multiple values successfully.

SQL query groups several pieces of data into different values in the same field, as follows: 1. It is necessary to use the slag and groupby clauses to group the slag according to one or more fields. 2. You can specify multiple fields in the groupby clause to get more subdivisions and groupings.

3. It is worth noting that the columns listed in the groupby clause must be listed in the select statement, or the input parameters of the aggregate function. Otherwise, the SQL engine won't be able to understand how to group the data.