Answer Posted / tauseef

select last_name,salary from(
select last_name,salary ,rownum rk from(
select distinct salary,last_name from employees order by
salary desc nulls last))
where rk=9


By this way u can find 2nd,3rd n nth highest salary wit the
name

explain the options of myisamchk to improve the performance of a table. : Sql dba

1007

---

Does normalization improve performance?

1031

---

Which sql most popular?

984

---

What are the different parts of a package?

1110

---

how can you create an empty table from an existing table? : Sql dba

1152

---

Mention what does the hierarchical profiler does?

1087

---

Can we use having without group by in sql?

982

---

Which is faster count (*) or count 1?

1026

---

what are the advantages of using stored procedures? : Sql dba

1103

---

What are the datatypes available in pl/sql ?

1098

---

What is transaction control language (tcl)?

1131

---

What is pessimistic concurrency control? : Transact sql

1083

---

List and explain the different types of join clauses supported in ansi-standard sql?

1352

---

Can cursors be part of a trigger body?

1637

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1019

---