Database, how to get the latest dates based on my records

Question

0.00/5 (No votes)

See more:

Hello programmers, got a question here supposed I have a table with this columns

CourseCategory               Course                  Date
I.T                          data management         2011
BSCS                         programming             2011
BSCS                         programming 2           2011
I.T                          hardware management     2010
ACT                          technical               2011    
BSCS                         Writing                 2010

My question is how can I get the latest date based on my table above, in this case 2011? Cause what i want is that when I create another term for next year the current term datas must be applied when I create it. Any tutorial regarding this?

Posted 11-Oct-11 19:41pm

janwel

Add a Solution

1 solution

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)

Mehdi Gholam · Accepted Answer · 2011-10-11T19:44:00

Solution 1

Use the following query :

SQL

select Max(Date) from tablename where course='Writing'

Posted 11-Oct-11 19:44pm

Mehdi Gholam

Comments

janwel 12-Oct-11 1:46am

ill try sir

janwel 12-Oct-11 1:50am

Sir how about if I use it in where clause for example ^^Select * from [table] where Date=Max[Date]^^ is this correct sir?

Vikas_Shukla_89 12-Oct-11 1:56am

hey janwel, try this
select * from dbo.Table where DATE = (select max(DATE) from dbo.Table)