SQL multi criteria query string 30

How can you write like this?

dr = , "select * from tbl_person where personid in ("+") or personid like '"+ viewstate["userpersonid"].tostring()+"_' or personid like '"+viewstate["userpersonid"].tostring()_"' and personid='"+viewstate["searchpersonid"].

tostring()+"'";

Change it like this, maybe there's a punctuation error, you look at the place where the or or and statement, you look at it, follow your logic, + brackets, bracket.

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.

How to query a field in SQL that meets two conditions.

Refer to the following:1In the computer, open the foxtable software, create a new **, such as the student evaluation results, and enter the data, as shown in the figure below.

2.Then, left-click the single-button attack menu and select [Miscellaneous], as shown in the image below.

3.Then, in the menu column, left-click [sqlquery] as shown in the image below.

4.Next, select the data source in the [sqlquery] window, as shown in the image below.

5.Then, in the [SqlQuery] window, enter the SQL query statement as shown in the image below.

6.Next, in the preview of the table, you can see the data displayed through the query statement, as shown in the following image.

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.

select * from user where name='Zhang San' and name ='Li Si'

select * from user where name in ('Zhang San','Li Si');

Analysis: Add relationship table and staff borrowing information table.

Add the borrowing mark field to the book table.

When the conditions are right, the query is very convenient. Welcome to ask, thank you for adopting!

select borrower from bookwhere title=book1

and not exist

select * from book where title = borrowed book2).

Available where....and statement.

For example, the data in the student table:

classid name age1 Zhang San 191 Li Si 201 Wang Wu 202 Zhao Liu 182 Sun Qi 212 Yang Ba 19If you want to check the information of a person whose classID is 1 and age is 20, you can use the following statement:

select * from student where classid=1 and age=20

The result is: classid name age1 Li Si 201 Wang Wu 20select * from student where classid=1 and age=20