bipin singh


{ City } mumbai
< Country > india
* Profession * software developer
User No # 8851
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 417
Users Marked my Answers as Wrong # 60
Questions / { bipin singh }
Questions Answers Category Views Company eMail




Answers / { bipin singh }

Question { Yardi, 320786 }

how to find the second highest salary from emp table?


Answer

use this query. it works great.

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?    415 Yes 59 No

Question { 12182 }

system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??


Answer

Try this this will works fine.

select convert(varchar,dateadd(day,2,getdate()),106)

Is This Answer Correct ?    2 Yes 1 No