Answer Posted / udayalakshmij

select emp_name,max(salary) from emp except(select max(salary) from emp);

How do you use join?

890

---

In what condition is it good to disable a trigger?

971

---

What is the difference between the conventional and direct path loader? : aql loader

1112

---

What is the difference between clustered and non-clustered index in sql?

959

---

how to present a past time in hours, minutes and seconds? : Sql dba

946

---

Can a primary key be a foreign key?

971

---

What is cross join example?

942

---

What is the execution plan in sql?

975

---

how can we repair a mysql table? : Sql dba

916

---

which tcp/ip port does sql server run on? : Sql dba

966

---

what is schema? : Sql dba

987

---

What is the difference between cross join and natural join?

963

---

What does dml mean?

930

---

What is data modelling in sql?

964

---

What is %type in pl sql?

926

---