mysql-MySQL中的group_concat函数怎么用sybase实现？
- WBOYOriginal
- 2016-06-06 09:39:381474browse
mysqlsybase
select distinct a.computername,a.mac , GROUP_CONCAT(distinct a.username) as usernames,GROUP_CONCAT(distinct a.userid) as userids from (select distinct nons.* , users.username,client.computername from noncontrol_softwares nons left join users on nons.userid=users.userid left join client on nons.mac=client.mac) as a group by a.mac
怎么将这段MySQL语句转换成sybase的？
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：数据-mysql 获取连续值的个数Next article：mysql-根据所给序号如何查询出分组1 和分组2?