functions corresponding to this database SQL

hailiang shen — Mon, 07 Sep 2009 22:06:01 -0400

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

Re: functions corresponding to this database SQL

Aldon Hynes — Sat, 12 Sep 2009 00:34:03 -0400

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

MATLAB Central Newsreader - functions corresponding to this database SQL

functions corresponding to this database SQL

Re: functions corresponding to this database SQL