Answer Posted / g sivanagaraju

SELECT sal
FROM emp e
WHERE &100=(SELECT COUNT(DISTINCT(SAL))
FROM emp
WHERE e.sal<=sal);

What sql does db2 use?

926

---

How do you write a subquery?

965

---

Write a sql query to get the third highest salary of an employee from employee_table?

1027

---

tell us something about heap tables. : Sql dba

1048

---

Is it possible to update views?

916

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

945

---

What is latest version of sql?

982

---

how to drop an existing table in mysql? : Sql dba

983

---

What is a composite primary key?

1031

---

Can we use joins in subquery?

1086

---

What is orm in sql?

993

---

how can we repair a mysql table? : Sql dba

914

---

How does an execution block start and end in pl sql?

900

---

Why do we use joins?

984

---

Can we update views in sql?

897

---