Answer Posted / selvaraj v, anna university co

Find the HIGHEST SALARY in Employee Table :
-------------------------------------------

select * from emp where sal=(select max(sal) from emp)
order by empno;


Find the 3'rd HIGHEST SALARY in Emp Table :
-----------------------------------------------

SELECT * FROM EMP e WHERE 3=(SELECT COUNT(*) FROM EMP x
WHERE x.SAL>=E.SAL);

It's e,x are ALIAS NAME of EMP Table.

What is nosql example?

969

---

What is nested table in pl sql?

1004

---

How do you change a value in sql?

965

---

What is the usage of when clause in trigger?

990

---

What are the various levels of constraints?

1059

---

Is stored procedure faster than query?

914

---

What are reports usually used for?

967

---

what is “go” in t-sql? : Transact sql

1040

---

How can I delete duplicate rows?

964

---

Is time a data type in sql?

852

---

what are the different functions in sorting an array? : Sql dba

968

---

What is the sql query to display the current date?

990

---

What is varray in pl sql?

1007

---

define join and explain different type of joins? : Sql dba

898

---

Does pl/sql support create command?

1044

---