Thanks so much for your replies!!

But, my table have only one column, the table structure look like --

Create table latest_value

(

[name] varchar(50)

)

Ignore my last post and try this CODE

---- For 2nd highest value

select max(salary) from employee_details e1

where 2 <=(select count(*) from employee_details e2 where e1.salary<= e2.salary)

---- For 2nd highest...

select max(salary) from employee_details e1

where 2 <=(select count(*) from employee_details e2 where e1.employeeid <= e2.employeeid)

Nice one, but frankly i m not satisfied with Mr. Ramesh answers, because i run and tried the query and found that sometimes it shows incorrect output. Sorry Boss...

select substring(column_name, 1, charindex(',,', column_name) -1) +

case

when replace(substring (column_name, charindex(',,', column_name), len(column_name)),',','') = ' ' then ''

when replace(substring (column_name, charindex(',,', column_name), len(column_name)),',','') <> ' ' then

+','+replace(substring (column_name, charindex(',,', column_name),...

Very easiest way for replacing comma from value

select replace (column_name, ',', '') from table_name

Thanks bro i have already done.

select convert(datetime, convert(float, getdate()) - floor(convert(float, getdate())))