Answer Posted / srijith pillai

This will give you third highest salary

select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;

what are the 'mysql' command line options? : Sql dba

1013

---

What are views in sql?

925

---

How many disk partitions should I have?

939

---

Is natural join and inner join same?

853

---

Which data type is a composite type?

931

---

Why we use sql profiler?

908

---

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

967

---

What are all types of user defined functions?

1004

---

What is cross join example?

940

---

Why use truncate instead of delete?

959

---

Why sql query is slow?

928

---

What is an emotional trigger?

927

---

How do you create a unique index?

986

---

What are tables and fields in the database?

1022

---

What is java sql driver?

1037

---