Latest Entry in the database

Question

0.00/5 (No votes)

See more:

SQL-server-2000

I have A table name
Patient
ptn_no ipno admission_date
1 1 12/12/11
1 2 14/12/11

i want the latest entry in this table for ptn_no 1.

Help me for the Sql Query
how can i match the latest entry through admission date

Posted 4-Dec-12 16:20pm

ankur789

Add a Solution

3 solutions

Solution 3

To get the latest record using the admission date column, the query can be built in several different ways.

One way is to select it using a non-correlated condition, for example:

SQL

SELECT *
FROM Patient
WHERE Admission_Date = (SELECT MAX(Admission_Date) FROM Patient)

The above will work only if there is no duplicates with the admission date.

Another option could be to use TOP, for example:

SQL

SELECT TOP(1)
       ptn_no,
       admission_date
FROM Patient
ORDER BY admission_date DESC

Again if there are duplicates for admission date, you will basically get a random record for the latest admission date.

Posted 4-Dec-12 17:18pm

Wendelius

Comments

Espen Harlinn 11-Dec-12 17:52pm

5'ed!

Wendelius 12-Dec-12 0:16am

Thank you :)

Solution 1

If you have a primary key or unique identity column, just sort by that descending and you will get the latest record right on top.

Posted 4-Dec-12 16:57pm

Abhinav S

Comments

ankur789 4-Dec-12 23:04pm

i Want only the latest single row in the entries
please provide sql query for it

Espen Harlinn 11-Dec-12 17:52pm

Good point :-D

Abhinav S 12-Dec-12 0:53am

Thanks Espen.

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)

Aarti Meswania · Accepted Answer · 2012-12-04T17:50:00

Solution 4

get records using desc order of admission date and ipno in case of similar date it will give you latest entry by ipno

SQL

SELECT top 1 *
FROM Patient 
where ptn_no = 1 
ORDER BY admission_date, Ipno DESC

Happy Coding!
:)

Posted 4-Dec-12 17:50pm

Aarti Meswania

Comments

Espen Harlinn 11-Dec-12 17:51pm

5'ed!

Aarti Meswania 11-Dec-12 20:43pm

thank you! :)