Answer Posted / sivasiva
create table emp
empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1
| Is This Answer Correct ? | 17 Yes | 12 No |
Post New Answer View All Answers
What is importing utility?
When would you use sql joins?
Can I use sql azure as a backup with log shipping or database mirroring?
What is BLOCK statements in SQL?
Explain temporary table vs table variable by using cursor alternative?
What is the difference between value type and reference type?
what are the different types of SSRS reports?
What guidelines should be followed to help minimize deadlocks?
When I run the sql server 2000 setup, it just hangs. What do I do?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Tell me what is the order in which the sql query is executed?
What is optimization and its types?
How can you append an identity column to a temporary table?
What do you understand by a view? What does the with check option clause for a view do?
What do we need queues in sql service broker?