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.

Why do we need view in sql?

968

---

What is sql partition function?

1183

---

How many sql commands are there?

1102

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1130

---

Write an sql query to select all records from the table?

1000

---

How can I tell if sql is running?

1032

---

Which is better join or inner query?

1014

---

How to revise and re-run the last sql command?

1145

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

945

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1579

---

Why do we need pl sql?

955

---

How to add new employee details in an employee_details table with the following details

1078

---

How to return multiple rows from the stored procedure?

950

---

Explain lock escalation? : Transact sql

1173

---

What is pl/sql table? Why is it used?

1013

---