Thread Subject: functions corresponding to this database SQL

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

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 “Group By” 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