SQL max function

Question

0.00/5 (No votes)

See more:

Hi everyone i hope you can help me!
Not sure if this is in the right place? so sorry if it is!

i have the following table named StockTable

StockName|StockPrice | StockDate

DOW 23 01/01/10
RSDB 15 01/01/10
DOW 22 02/01/10
RSDB 11 02/01/10
DOW 24 03/01/10
RSDB 12 03/01/10
DOW 25 04/01/10
RSDB 16 04/01/10

I want to use a max function to display the highest stock price for a certain stock name entered into a text box
currently i have the folowing code which returns the highest stock price in the whole table.

SELECT * FROM stockTable
WHERE StockPrice=(select max(StockPrice) StockTable)

I want to be able to enter the string RSDB into a text box and return the max StockPrice for RSDB which would be:

StockName|StockPrice | StockDate
RSDB 16 04/01/10

Hope someone can help me with this as ive tried as much as i can!
If anyone needs clarification please ask

Thanks in advance! : )

Richard

Posted 16-Jan-10 7:13am

necrokill1985

Add a Solution

2 solutions

Solution 2

Thanks for your solution but i worked it out

it is

SELECT * FROM StockTable
WHERE StockPrice=(select max(StockPrice) from StockTable
WHERE StockName = @StockName)

Posted 16-Jan-10 8:59am

necrokill1985

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Accepted Answer · 2010-01-16T08:36:00

Solution 1

SELECT 
    max(StockPrice)
FROM
	StockTable
WHERE
	StockName = @StockName

Pass the stock name as paramter and this should help you.

Posted 16-Jan-10 8:36am

Manas Bhardwaj