Limiting the number of queries returns in SQL Server 2008
- by Jose Sotero Villegas III
This is my query
SELECT Fullname, rank, id_no, TIN, birthdate,
hair, eyes, Blood, height, weight, marks, name, address
FROM [******_DOMAIN\****_*****].*******view
Problem is, source table has too many duplicates, how do I my limit query to the latest row on the database?
I'm using SQL Server 2008.
Thanks In advance
My next problem is that the view shows me a birthdate string format of yyyymmdd, I need to change it to mm/dd/yyyy can please provide me a function? using the same string above?