Answer Posted / prashanth

select max(sal) from employee where sal<(select max(sal)
from employee)

How to select unique records from a table?

1053

---

What is constant in pl sql?

1013

---

what is acid property in database? : Sql dba

1024

---

Give the order of sql select?

1133

---

What does the file extension accdb stand for?

968

---

What is not in sql?

941

---

What is sql comments?

1072

---

what are the types of join and explain each? : Sql dba

1036

---

What is latest version of sql?

1041

---

What packages are available to pl/sql developers?

1044

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1116

---

Can we group by two columns in sql?

989

---

How do I count rows in sql query?

986

---

Is it possible to create the following trigger: before or after update trigger for each row?

1282

---

How to run sql statements with oracle sql developer?

1061

---