/SQL/Select * where id = 1,2,3

Select * where id = 1,2,3

Select * where id = 1,2,3

SELECT * FROM Table WHERE id IN (1,2,3,4,5) AND ColB = (SELECT ColB FROM Table WHERE id IN (1,2,3,4,5) ORDER BY FIELD(id,1,2,3,4,5) LIMIT 1)

0

Source: stackoverflow.com

Similar codes

1 vote195 views1 answer
Find logged in users mysql
SQL
4 votes221 views3 answers
Postgres set default value
SQL
1 vote222 views1 answer
Get current date in pyspark sql
SQL
2 votes208 views2 answers
Mysql user access to database
SQL
16 votes207 views1 answer
Mysql mediumint max value
SQL
4 votes217 views1 answer
Oracle nls_date_format
SQL
0 vote218 views1 answer
Mysql into outfile with headers
SQL
1 vote229 views1 answer
Mysql show current queries
SQL
4 votes213 views2 answers
What is table in sql
SQL
0 vote217 views1 answer
Query to get all primary keys and foreign key
SQL

Share