Question

sql从同一表里查询多条不同条件的数据

请问如何一次从表“A”查询三个数据：
1. a_id, a_title, a_name 条件：a_id=10
2. top 1 a_id, a_title 条件：a_id>10
3. top 1 a_id, a_title 条件：a_id<10
请问如何写这个查询语句，谢谢！
如果按shutao917所说的union all 的方法会提示：关键字‘union’附近有语法错误！

Answer 1

select a_id, a_title, a_name from A where a_id=10
select top 1 a_id, a_title from A where a_id>10
select top 1 a_id, a_title from A where a_id<10

Answer 2

select a_id, a_title, a_name from A where a_id=10
union all
select top 1 a_id, a_title, a_name from A where a_id>10
union all
select top 1 a_id, a_title, a_name from A where a_id<10

Answer 3

select * from A where a_id='10'
select * from A where a_id>'10'
select * from A where a_id<'10'