debasish


{ City } hyderabad
< Country > india
* Profession * sr s/w eng
User No # 30939
Total Questions Posted # 0
Total Answers Posted # 5

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

Users Marked my Answers as Correct # 34
Users Marked my Answers as Wrong # 14
Questions / { debasish }
Questions Answers Category Views Company eMail




Answers / { debasish }

Question { IBM, 163895 }

how to find nth highest salary


Answer

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

Is This Answer Correct ?    19 Yes 11 No

Question { SunGard, 19294 }

How do you handle data concurrency in .NET ?


Answer

concuracy is handled by the help of timestamp..
or checking the original data onece again before edit or
delete.

Is This Answer Correct ?    6 Yes 1 No


Question { 4542 }

plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005


Answer

in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup

there is no sqlserver2002 hope so

Is This Answer Correct ?    3 Yes 0 No

Question { TCS, 9898 }

How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1

please give any idea on that



Answer

the good away to count is convert it to a arry and the
count the array element.. you can do as you like with array.

Is This Answer Correct ?    0 Yes 1 No

Question { 3548 }

Can some one please help with a query which will take only
max value of a column in a join.


Answer

select max(alias.colomnname) from table alias
join table alis on

Is This Answer Correct ?    6 Yes 1 No