Answer Posted / abhishekjaiswal

select department_id,salary from employees e 
where salary<(select trunc(avg(salary)) 
from employees where department_id=e.department_id;

how to convert numeric values to character strings? : Sql dba

1039

---

Can a select statement fire a trigger?

1100

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2024

---

How can a pl sql block be executed?

893

---

What are analytic functions in sql?

974

---

how to check myisam tables for errors? : Sql dba

1262

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

946

---

what is sub-query? : Transact sql

1047

---

what are ddl statements in mysql? : Sql dba

1114

---

What is asqueryable?

905

---

How to display Row Number with Records in Oracle SQL Plus?

993

---

In what condition is it good to disable a trigger?

972

---

Write the command to remove all players named sachin from the players table.

1124

---

What is the least restrictive isolation level? : Transact sql

1001

---

How do I find duplicates in sql?

879

---