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...

sandeep rana


{ City } ludhiana
< Country > india
* Profession * it executive
User No # 58867
Total Questions Posted # 0
Total Answers Posted # 6

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

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 9
Questions / { sandeep rana }
Questions Answers Category Views Company eMail




Answers / { sandeep rana }

Question { 11625 }

IN Vs OR operator which is best to use sql server.


Answer

Both are used for different purposes like...

select * from table where data in(1,2,3,4,5,6)


select * from table where data in(1,2,3,4,5,6) or data1
like('%s','%t')

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 31693 }

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com


Answer

Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary

Is This Answer Correct ?    0 Yes 0 No


Question { Eforce, 31774 }

is there more the two primary key in a single table?


Answer

If table has more than one primary key is called
composite key....

Is This Answer Correct ?    1 Yes 0 No

Question { Wipro, 11565 }

which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM


Answer

select * from table where columndata not in(select
columndata from table where date between '' and '')

Is This Answer Correct ?    0 Yes 4 No

Question { 11990 }

What would be the Expected Salary For SQL Server Developer
for 3 years exp. as per indian market?


Answer

DEPEND ON COMPANY STANDARD AND TALENT OF DEVELOPER

Is This Answer Correct ?    1 Yes 0 No

Question { HCL, 12696 }

how to find the second salary?


Answer

select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)

Is This Answer Correct ?    2 Yes 5 No