Latest Entry in the database

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:

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:

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.

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

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

Happy Coding!
:)