Answer Posted / ravi patel

for the table emp
ID NAME
1 ravi
2 umang
1 ravi
3 nishant

now fire the query as beleow

select * from emp group by id,name having count(id)>1 and
count(name)>1;

What is t sql in sql server?

1055

---

What is range partitioning?

948

---

What is the purpose of a sql?

962

---

When to use inner join and left join?

937

---

what are myisam tables? : Sql dba

1016

---

Can function return multiple values in sql?

1031

---

What is the difference between sql and isql*plus?

1073

---

What is record variable?

961

---

Why is sql better than hql?

971

---

what is a field in a database ? : Sql dba

1043

---

Can we rename a column in the output of sql query?

977

---

what are date and time data types? : Sql dba

962

---

How do I add a primary key to a table?

1028

---

Define tables and fields in a database

1113

---

What is t-sql? : Transact sql

968

---