Answer Posted / debasish sinha

select ename,sal,deptno
from emp
where sal =
(
select max(sal)
from emp
where level=2
connect by prior sal>sal
group by level
)

Is record in pl sql?

966

---

What is dynamic query?

969

---

What is procedure in pl sql?

1040

---

Can we rollback after truncate?

1029

---

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

1187

---

How do I edit a stored procedure?

988

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

What are all the different normalization?

1037

---

Are null values same as that of zero or a blank space?

1024

---

What is the purpose of a sql?

973

---

how to fetch alternate records from a table? : Sql dba

1107

---

What kind of join is join?

960

---

Which software is used for pl sql programming?

982

---

explain the difference between bool, tinyint and bit. : Sql dba

995

---

What are crud methods?

1027

---