Answer Posted / pramod sharma

select f_name max(salary)from emp,dep
where salary<(select max(salary)from emp)

What is group function in sql?

1016

---

How sql query is executed?

1127

---

What are the types of join in sql?

1098

---

What are different methods to trace the pl/sql code?

1115

---

How do you remove duplicate records from a table?

936

---

What is the difference between the conventional and direct path loads? : aql loader

1392

---

Explain 3 basic parts of a trigger.

1313

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1202

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1000

---

What does count (*) mean in sql?

1579

---

What is sqlerrd?

966

---

What is a database event trigger?

1157

---

Is sql database free?

970

---

What are the benefits of stored procedures?

1059

---

how to use myisamchk to check or repair myisam tables? : Sql dba

968

---