MATLAB Central > MATLAB Newsreader > functions corresponding to this database SQL

Thread Subject: functions corresponding to this database SQL

Subject: functions corresponding to this database SQL

From: hailiang shen

Date: 7 Sep, 2009 22:06:01

Message: 1 of 2

Reply to this message

Add author to My Watch List

View original format

Flag as spam

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

Subject: functions corresponding to this database SQL

From: Aldon Hynes

Date: 12 Sep, 2009 00:34:03

Message: 2 of 2

Reply to this message

Add author to My Watch List

View original format

Flag as spam

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

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag	Applied By	Date/Time
sql	Sprinceana	8 Sep, 2009 04:44:24
matlab sql func...	Sprinceana	8 Sep, 2009 04:44:24

Feed for this Thread

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.