Interview Questions Answers in SQL Server

Questions / { sandeep rana }

Questions Answers Category Views Company eMail

Answers / { sandeep rana }

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

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 { Systematix, 26170 }

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

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

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

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