Answer Posted / shiva

select sal from emp group by sal;
this query group the same salary.Suppose the table contains 30
records in that same sal is 3 times repeating by using above
query it will fetch only 27 rows of sal.So it wont give the duplicate sal.

How to run sql commands in sql*plus?

1183

---

How many unique keys can a table have?

1016

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1016

---

Does oracle roll back the transaction on an error?

1014

---

How much does a sql dba make? : SQL DBA

948

---

Name some usages of database trigger?

1021

---

How can triggers be used for the table auditing?

1070

---

Explain the select statement in sql?

1112

---

What is a composite primary key?

1095

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

What is row_number () in sql?

984

---

What are the three forms of normalization?

1045

---

What is t sql used for?

1015

---

Cite the differences between execution of triggers and stored procedures?

1078

---

What type of database is cloud sql?

1102

---