MSSQL statement for Highest Price

Question

3.00/5 (1 vote)

See more:

tow column

Price and Order Date

I would like to write mssql query for selecting highest price from Price Column during last two weeks of Order Date column.

Posted 12-Dec-12 5:01am

ttds

Updated 12-Dec-12 5:26am

Herman<T>.Instance

v2

Add a Solution

Comments

Herman<T>.Instance 12-Dec-12 11:26am

you tag C# but you mean SQL

2 solutions

Solution 2

SQL

SELECT MAX(Price) FROM myTable WHERE DateDiff(ww, OrderDate, getDate()) < 2

More info about the use of DateDiff can be found here[^].

Posted 12-Dec-12 5:25am

Herman<T>.Instance

Updated 12-Dec-12 5:29am

v2

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)

OriginalGriff · Accepted Answer · 2012-12-12T05:21:00

Solution 1

Try:

SQL

SELECT MAX(Price) FROM myTable WHERE OrderDate BETWEEN '2012-12-12' AND '2012-11-28'

Posted 12-Dec-12 5:21am

OriginalGriff

Comments

Herman<T>.Instance 12-Dec-12 11:25am

these are fixed dates while other more flexible functions are available im MSSql

OriginalGriff 12-Dec-12 11:35am

I agree, but I am assuming the OP is bright enough to be able to pass the appropriate dates through as parameters from whatever presentation layer language he is using. Bear in mind that his definition of "last two weeks" might be "a week last Monday", or a fortnight before last Monday", not "exactly two weeks back from today"

Killzone DeathMan 12-Dec-12 11:27am

I love that OriginalGriff, always the best answer!
I think we must speak in Private!

Herman<T>.Instance 12-Dec-12 11:31am

I also appreciate is correct way of answering questions on this forum, but sometimes (mostly SQl) I can give some other solutions

Killzone DeathMan 13-Dec-12 4:33am

That's how it rolls :P

OriginalGriff 12-Dec-12 11:45am

What about? :laugh:

Killzone DeathMan 13-Dec-12 4:31am

About some projects we can do together :D