Name designation promotedto newdestin
Dr Dharam Raj Singh Scientist 22 Jan 2008 Scientist S.S
Dr Dharam Raj Singh Scientist 22 Jan 2010 Scientist S.S

how i wl select one row from these two rows.
this is an eg. in mine table there is lots of rows of this type

thanks

Well, elaborate your issue in detail, are you trying to fetch this from SQL table, or trying to set this in your page? Please be more specific as its difficult to understand from this post.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

this record are fetching from database
u have seen difference between dates this is because
dharam done two degrees (Msc & Phd) therefore two records are showing
but i want to show record of (phd "second one record of dharamRAj")
pls help me
 thnks

create table omnlin(asp uniqueidentifier)