Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 { Cognizant, 178824 }

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 { Infogain, 21278 }

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 { 5202 }

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, 11330 }

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 { 4100 }

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