Answer Posted / nitin

select max(salary) from emp where salary<>(select
max(salary) from emp);

Is it possible to create startup or shutdown trigger for on-schema?

981

---

What is a variable in sql?

953

---

What is set serveroutput on?

1088

---

Can dml statements be used in pl/sql?

1021

---

What is example of database?

987

---

How do you optimize a stored procedure query?

939

---

Can we use two order by clause in query?

919

---

What is difference between table and view?

979

---

What are the most important ddl statements in sql?

1027

---

How would you reference column values before and after you have inserted and deleted triggers?

1021

---

How many types of indexes are there in sql?

935

---

How do you remove duplicates without using distinct in sql?

921

---

what are the different type of normalization? : Sql dba

974

---

what are all different types of collation sensitivity? : Sql dba

932

---

How do I find sql profiler?

886

---