SQL查询选择员工姓名从A到E范围开始。 [英] SQL Query To select Employee name Start with A to E range.

问题描述

亲爱的先生，



我有一个应用程序，我必须在范围内显示员工姓名。



AE | F-J | K-O | P-T | UZ



我想要一个SQL查询来选择名称范围在 A 之间的员工  E 等。





当用户点击链接 AE ，它应显示从A到E的所有员工姓名。





提前致谢。



问候

Asutosha

解决方案

你可以使用LIKE。尝试类似这样的查询：

T-SQL：

 SELECT姓名FROM员工WHERE名称喜欢'[AE]％'

MySQL：

 SELECT姓名FROM员工WHERE名称REGEXP'^ [AE]。* 

'

祝你好运！

有什么不对使用简单的 BETWEEN ？

  SELECT  name  FROM  test  WHERE  name  BETWEEN  '  a'  AND  '  e' 

其中名称是列名， test 是表名。



这对于最终的SP来说甚至很容易参数化。



干杯！

Dear Sir,

I have a Application in which I have to display the name of Employee in range like .

A-E | F-J | K-O | P-T | U-Z

I want a SQL query to select those employee whose Names range between A to   E and so on.


When a user click on the link A-E , it should display all the employee name starting from A to E.


Thanks in advance.

Regards
Asutosha

解决方案

You could use LIKE for that. Try something like this query:
T-SQL:

SELECT Name FROM Employees WHERE Name LIKE '[A-E]%'

MySQL:

SELECT Name FROM Employees WHERE Name REGEXP '^[A-E].*

'

Good luck!

What is wrong with a simple BETWEEN?

SELECT name FROM test WHERE name BETWEEN 'a' AND 'e'

Where name is column name and test is table name.

This is even easy to parametrise for an eventual SP.

Cheers!

这篇关于SQL查询选择员工姓名从A到E范围开始。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！