Answer Posted / hari thorat

select max(salary) from employee where salary <(select max(salary) from employee);

What is java sql package?

1026

---

explain advantages of myisam over innodb? : Sql dba

1017

---

What is the difference between a procedure and a function?

1013

---

Differentiate between % rowtype and type record.

1197

---

Why indexing is needed?

940

---

what is sql server agent? : Sql dba

1030

---

What is view explain with example?

887

---

what is column? : Sql dba

962

---

what is a field in a database ? : Sql dba

991

---

What is materialized view. What are different methods of refresh?

1332

---

What is the example of procedure?

878

---

What is duration in sql profiler trace?

1022

---

How can I get the number of records affected by a stored procedure?

1003

---

What are reports usually used for?

969

---

What are the parts of a sql statement?

1030

---