Get the latest result (new in sql)

[Casper2]

I have a huge table with multiple record for one patient but I only want the latest
result within a year. How can I do it?

thanks, :confused:
Casper2

[lipsa]

hi,
what cloumns are there in ur table,if u hv date colun then u can easily do that
with where ...LIKE,IN clauses
select * from <table> where <date_column> like '%yyyy%'
Regards,
Lipsa

[Banfa]

And also use ORDER BY and LIMIT clauses to order by date (most recent first) and limit the return result to 1 record.

[iam_clint]

Banfa i do believe LIMIT is mysql

I am pretty sure its TOP in sql server.

[iam_clint]

select top 1 * from <table> where <date_column> like '%yyyy%' order by <date_column> desc

So this should do what your looking for i would think.

[Banfa]

Banfa i do believe LIMIT is mysql

I am pretty sure its TOP in sql server.

That's good to know since I am just about to start using SQL Server at work :D

Thank You