Answer Posted / suba

(Instead of 3 we can find N highest value)

select min(sal) from emp e where 3>(select count(sal) from
emp where sal>e.sal);

how to add a new column to an existing table in mysql? : Sql dba

1049

---

What is optimistic concurrency control? : Transact sql

971

---

What is the difference between left join and right join?

930

---

What is recursive join in sql?

985

---

How do I partition in sql?

944

---

Explain ddl statements in pl/sql?

994

---

What is sql procedures and functions?

992

---

What is trigger in sql and its types?

1042

---

Is primary key always clustered index?

993

---

Explain the methods used to protect source code of pl/sql.

1007

---

How do you add a column to a table?

1039

---

Can you call pl/sql package functions from within a fast formula?

1021

---

Is not null in sql?

966

---

What is an example of translating a date into julian format?

1100

---

Explain the rollback statement?

988

---