i also chosen none of the above which actully should be the answer also i am not at all satisfied with the explanation saying that it is a...

just try simple change in your last line just reverse the condition in exists clause and change the condition in subquery

means

replace

and where condition...

ya this is also my assumption but i waann to knw view of u people for that so only i asked

thaks for ur quick reply....

thx dear it really works fine

thx fro your quick reply it is really a good idea to use rank function

thx for ur suggestion:w00t:

i tried like this

declare @id int

set @id=select top 2 id_num from new_employes order by id_num desc

select id_num from new_employes where id_num=(select min(@id)from new_employes)

but i am getting...

this is not the ans of my question please dont ask question if u dont wann to give ans.//

Thats really true

its not just a matter of having A DEGREE but its matter of your way of utilizing you abilities in the sensiful manner .

Even in a long...

Really its very intersting to know the people who having non technical degrees can also become a succesfull DBA. It sounds really great for me as having the master degree...

thx a lot dear

Thx a lot Mr. Reddy ,,,,,:-)

thx for ur suggession but i knw tht very well:)

Actually this code i got from here only.....

and this code is given under the TITLE "Query to split values by Coma """:D

So i tried but i got an error:)