Just use multiple in-clauses to get around this:
select field1, field2, field3 from table1
where name in ('value1', 'value2', ..., 'value999')
or name in ('value1000', ..., 'value1999')
or ...;
More Related Contents:
- How can I solve ORA-00911: invalid character error?
- SQL Query to concatenate column values from multiple rows in Oracle
- Oracle Differences between NVL and Coalesce
- Grouped LIMIT in PostgreSQL: show the first N rows for each group?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- How can I query a value in SQL Server XML column
- SQL Server indexes – ascending or descending, what difference does it make?
- Update records in table from CTE
- Write a number with two decimal places SQL Server
- How to get a list of column names on Sqlite3 database?
- TSQL – Cast string to integer or return default value
- SQL Server date format function
- SQL: Select dynamic column name based on variable
- The SQL OVER() clause – when and why is it useful?
- Eliminating duplicate values based on only one column of the table
- How to see all the tables in an HSQLDB database?
- Use A Union Or A Join – What Is Faster [closed]
- Aggregating (x,y) coordinate point clouds in PostgreSQL
- Merge overlapping date intervals
- How does a Recursive CTE run, line by line?
- Improving performance of cluster index GUID primary key
- Hive – Unpivot functionality in hive
- Mysql strip time component from datetime
- How to find out what is locking my tables?
- The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
- Add a column to existing table and uniquely number them on MS SQL Server
- SQL: Two select statements in one query
- How to execute a stored procedure inside a select query
- SQL Inner Join On Null Values
- PostgreSQL: Full Text Search – How to search partial words?