Answer Posted / justus
create table emp
empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empname from emp group by empname having count(empname)>1
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Does group by or order by come first?
List all types of constraints in sql server?
What happens if you are trying to access a schema not owned by you?
Explain the steps needed to create a scheduled job?
What Is Rdbms?
What are group functions in query statements in ms sql server?
How to enable/disable indexes?
Ms sql server index?
How do I run a trace in sql server?
Which are the important points to note when multilanguage data is stored in a table?
What types of Joins are possible with Sql Server?
What is difference between equi join and natural join?
How to include text values in sql statements?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?