Answer Posted / arindam

select min(sal) from
(
select sal from
(
select distinct sal from emp order by sal desc
)
where rownum<=3
)
where rownum <4

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

914

---

What are the three forms of normalization?

1010

---

What plvcmt and plvrb does in pl/sql?

1268

---

Can you do multiple joins in sql?

995

---

What is left inner join in sql?

999

---

what is 'mysqlshow'? : Sql dba

986

---

What is trigger in flip flop?

975

---

Does sql support programming?

1025

---

Is a table valued function object?

971

---

What is date functions?

985

---

How do I enable sql encryption?

984

---

Can instead of triggers be used to fire once for each statement on a view?

914

---

What is offset in sql query?

1085

---

What are the different dcl commands in sql?

1096

---

Why do we use cursors?

942

---