Answer Posted / murali

select level,max(sal) from emp where level=&levelno connect by prior sal>sal group by level;

What is denormalization in a database?

1054

---

What are the different tcl commands in sql?

1176

---

What is data manipulation language?

1188

---

what is myisam? : Sql dba

1085

---

Is left join inner or outer by default?

1020

---

what are the features and advantages of object-oriented programming? : Sql dba

1011

---

What are variables in pl sql?

1167

---

what is rollback? : Sql dba

1112

---

What is left join in sql?

1051

---

Where is all the data on the internet stored?

1014

---

How do I view a view in sql?

951

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970

---

how many columns can be used for creating index? : Sql dba

946

---

List the ways to get the count of records in a table?

900

---

Explain the difference in execution of triggers and stored procedures?

1022

---