Interview Questions Answers in SQL Server, ASP.NET

jaleel

{ City } madurai
< Country > india
* Profession * software engineer
User No # 64918

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 # 4
Users Marked my Answers as Wrong # 3

Questions / { jaleel }

Questions Answers Category Views Company eMail

Answers / { jaleel }

Question { 10442 }

How reterive duplicate value in SQL?

Answer

create table emp (empid int,empname varchar)

insert into emp values (101,'a')
insert into emp values (102,'b')
insert into emp values (103,'a')
insert into emp values (104,'c')
insert into emp values (105,'a')

select * from emp

SELECT EmpName,Count(EmpID)Cnt From Emp Group By EmpName
Having Count(EmpName) > 1

Is This Answer Correct ?

2 Yes

0 No

Question { HCL, 8921 }

What is WCF? Pls Explain clearly with exmple.

Answer

unified programming model for building service-oriented
applications. It enables developers to build secure,
reliable, transacted solutions that integrate across
platforms and interoperate with existing investments

Is This Answer Correct ?

2 Yes

3 No