如何从具有两个条件的表中选择数据(How to select data from table with two condition)

如何从具有两个条件的表中选择数据(How to select data from table with two condition) mysql

我需要从表中选择带有union的两个条件的数据，或者如果表中有任何条件

name special Deepak s mukesh v dinesh s girgesh v Deepak s mukesh v dinesh s girgesh v Deepak s mukesh v dinesh s girgesh v

查询获取数据...

SELECT NAME FROM student WHERE special = "s" LIMIT 2 UNION SELECT NAME FROM student WHERE special = "v" LIMIT 2

但它在联合之前只给出了第一个条件......如何从单个表中获得两个不同的条件数据

I need to select data from table with two condition with union or if any for table

name special Deepak s mukesh v dinesh s girgesh v Deepak s mukesh v dinesh s girgesh v Deepak s mukesh v dinesh s girgesh v

query for fetching data...

SELECT NAME FROM student WHERE special = "s" LIMIT 2 UNION SELECT NAME FROM student WHERE special = "v" LIMIT 2

but its gives only first condition before union... how to get two different condition data from single table

最满意答案

根据MySQL的UNION文档 ：

要将ORDER BY或LIMIT应用于单个SELECT，请将子句放在括起SELECT的括号内

---

所以你想要使用：

(SELECT NAME FROM student WHERE special = "s" LIMIT 2) UNION (SELECT NAME FROM student WHERE special = "v" LIMIT 2)

Per MySQL's documentation on UNION:

To apply ORDER BY or LIMIT to an individual SELECT, place the clause inside the parentheses that enclose the SELECT

---

So you'd want to use:

(SELECT NAME FROM student WHERE special = "s" LIMIT 2) UNION (SELECT NAME FROM student WHERE special = "v" LIMIT 2)