Answer Posted / jaleel ahamed s
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 |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows in ms sql server?
Explain indexes disadvantages?
How to assign new column names in a view?
What is deploy, process and build? : sql server analysis services, ssas
Explain transaction server distributed transaction?
How do you delete duplicate records in sql server?
What are subqueries in sql server?
Describe how to use linked server?
What is 3nf normalization?
What is a self join in sql server?
How to convert numeric values to integers in ms sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Is the primary key column of a table an index in ms sql server?
What different steps will a sql server developer take to secure sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?