Path: news.mathworks.com!not-for-mail
From: "Aldon Hynes" <aldon.hynesREMOVESPAM@toomre.com>
Newsgroups: comp.soft-sys.matlab
Subject: Re: functions corresponding to this database SQL
Date: Sat, 12 Sep 2009 00:34:03 +0000 (UTC)
Organization: Toomre Capital Markets LLC
Lines: 16
Message-ID: <h8eq9r$p94$1@fred.mathworks.com>
References: <h84049$3e8$1@fred.mathworks.com>
Reply-To: "Aldon Hynes" <aldon.hynesREMOVESPAM@toomre.com>
NNTP-Posting-Host: webapp-03-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1252715643 25892 172.30.248.38 (12 Sep 2009 00:34:03 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Sat, 12 Sep 2009 00:34:03 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1979438
Xref: news.mathworks.com comp.soft-sys.matlab:569897


I'm not sure if this is what you are looking for, but I had to write something fairly similar to a Group By function for Matlab recently.  

You can read about it at 
Performing an SQL Style &#8220;Group By&#8221; in Matlab
http://www.toomre.com/node/801

Aldon

"hailiang shen" <hlshen2005@gmail.com> wrote in message 
<h84049$3e8$1@fred.mathworks.com>...
> I am manipulating a matrix, with database SQL, it is written as:
> select column1, column2, min(column3) from matrix group by column1, column2.
> 
> Is there any function in Matlab can finish this job?
> 
> Thanks for any input