Answer Posted / humayun quaiser

slect max(sal) from emp
where sal not in (select max(sal) from emp);

or

select max(sal) from emp
where sal<(select max(sal) from emp);

or

select distinct sal from emp e
where 1=(select count(distinct sal) from emp
where sal>e.sal);

What type of join is sql join?

986

---

How many types of index are there?

1044

---

List out the acid properties and explain?

959

---

what are the differences between require and include, include_once and require_once? : Sql dba

1027

---

what is csv? : Sql dba

1001

---

What are the two types of exceptions in pl/sql?

1052

---

How is a process of pl/sql compiled?

1161

---

What is nvarchar max in sql?

1020

---

what is query cache in mysql? : Sql dba

1040

---

What is database sql?

1058

---

What are the different operators available in sql?

1003

---

What is the file extension for sql database?

1006

---

what is an extent ? : Sql dba

1105

---

How many databases can sql express handle?

989

---

What is primary key and foreign key?

962

---