Answer Posted / priya

select coloumn_name ,count(*) from table_name
group by coloumn_name
having count(*) > 1;

Write a query to find the names of users that begin with "um" in sql?

703

---

Which are the different character-manipulation functions in sql?

719

---

What is pivot query?

830

---

What is an exception in PL/SQL? What are the two types of exceptions?

851

---

How to write a query to show the details of a student from students table whose

755

---

---

What are stored procedures in mysql?

763

---

Which normal form is best?

675

---

Can we change the table name in sql?

706

---

What is difference between rank () row_number () and dense_rank () in sql?

805

---

How to pipe multiline string to isql?

758

---

what is meant by urlencode and urldocode? : Sql dba

770

---

What is the starting oracle error number? What is meant by forward declaration in functions?

738

---

what is the stuff function and how does it differ from the replace function? : Sql dba

788

---

What is a Mapplet?

824

---

How do you run a query?

768

---