Answer Posted / dharmendra yadav

select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;

What is a behavioral trigger?

980

---

Explain what is sql?

1119

---

Can we write ddl statements in functions?

1121

---

What is pl sql and why it is used for?

1114

---

explain commit and rollback in mysql : sql dba

1025

---

How do you modify a table in sql?

1130

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1197

---

Is keyword pl sql?

1012

---

What is offset in sql query?

1126

---

What is parameter substitution in sql?

1035

---

What is cross join example?

1013

---

What are schema-level triggers?

1106

---

Name the operator which is used in the query for pattern matching?

961

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

998

---

What is a constraint?

1029

---