Answer Posted / dharmendra

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

Why stored procedures are faster than query?

1032

---

How will you distinguish a global variable with a local variable in pl/sql?

1158

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

997

---

How do you remove duplicate records from a table?

945

---

What is sql data?

999

---

Explain table and field in sql?

1068

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

Are pl sql variables case sensitive?

1053

---

How can I delete duplicate rows?

1022

---

what is a constraint? : Sql dba

1181

---

Explain what is an index?

1064

---

Can you join views in sql?

961

---

what are date and time intervals? : Sql dba

1062

---

What are field types?

1009

---

How to run pl sql program in mysql?

1026

---