Limiting the number of queries returns in SQL Server 2008
Posted
by
Jose Sotero Villegas III
on Stack Overflow
See other posts from Stack Overflow
or by Jose Sotero Villegas III
Published on 2012-07-07T01:51:31Z
Indexed on
2012/07/07
9:16 UTC
Read the original article
Hit count: 169
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?
© Stack Overflow or respective owner