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);

How do you use join?

993

---

What program will open a mdb file?

1019

---

where are cookies actually stored on the hard disk? : Sql dba

1079

---

What is a table?

1057

---

what is log shipping? : Sql dba

1165

---

What are views in sql?

1037

---

What is null in pl/sql?

1119

---

What is the purpose of the primary key?

1117

---

Can I learn sql in a week?

1119

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

---

Is not null in sql?

1043

---

How can I see all tables in sql?

1142

---

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

1437

---

Explain the working of foreign key?

1136

---

What is sql character function?

1148

---