Answer Posted / anonymous

select Max(salary) from test where salary not in(select Max
(salary) from test);

What's the procedure?

933

---

What is the purpose of the partition table?

1049

---

Can we insert data into view?

909

---

How do I tune a sql query?

981

---

What is substitution variable in pl sql?

1051

---

What is set serveroutput on in pl sql?

1303

---

Which is better varchar or nvarchar?

1001

---

What is difference between ms sql and mysql?

971

---

how tsql statements can be written and submitted to the database engine? : Transact sql

1001

---

How to use transactions efficiently : transact sql

1061

---

How do you declare a constant?

965

---

Why do we create stored procedures & functions in pl/sql and how are they different?

954

---

Explain the components of sql?

1068

---

What is clustered index in sql?

1057

---

what is the different between now() and current_date()? : Sql dba

1027

---