Thread: group_concat in MySQL
View Single Post
  #26 (permalink)  
Old 08-14-2007, 08:06 AM
Murali Murali is offline
D-Web Master
  
Join Date: Feb 2007
Location: India-Chennai.
Posts: 386
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: group_concat in MySQL
Hi Kumaresan,

Code:
SELECT GROUP_CONCAT(A.NAME) FROM (SELECT * FROM E_EMPLOYEE LIMIT 2) A -- returns only two name
Works Fine.....Thanks
__________________
-Murali..
Reply With Quote