sql statement by mssql

Question

1.00/5 (3 votes)

See more:

C#

How to write the sql statement
to select the Price of latest order date from the Price talbe

thanks,

Posted 20-Jan-13 22:51pm

ttds

Add a Solution

Comments

Mohd. Mukhtar 21-Jan-13 4:55am

What have you tried so for?

André Kraak 21-Jan-13 5:01am

In order for us to help we need more information.
Please supply table structure (including primary key) and data sample (both table and expected result).

2 solutions

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)

Herman<T>.Instance · Answer 1 · 2013-01-20T22:58:00

Solution 1

Based on your too less information

SQL

select top 1 price from PriceTable order by OrderDate Desc

Posted 20-Jan-13 22:58pm

Herman<T>.Instance

Comments

__TR__ 21-Jan-13 5:27am

Good answer. 5!

owencampbell 21-Jan-13 5:44am

He mentions mysql so you'll have to use LIMIT 1 at the end instead of Top 1 but considering the lack of info s/he is lucky to get a response anyway.

select price from PriceTable order by OrderDate Desc limit 1

__TR__ 21-Jan-13 6:45am

The subject of this question read
sql statement by mssql
So i am assuming its MS-SQL server. If the OP was looking for a solution in MySql s/he can refer your comment :)

Mohd. Mukhtar · Answer 2 · 2013-01-20T23:05:00

Solution 2

Try IDENTITY to get the last inserted record.

Posted 20-Jan-13 23:05pm

Mohd. Mukhtar

Comments

Herman<T>.Instance 21-Jan-13 6:49am

scope_identity() function you mean.