Answer Posted / sanjay kumar

Select * from
(select distinct salary, dense_rank()over (Order by salary desc) rk from emp)
Where rk=100;

How do you go back in sql?

942

---

Where not exists in sql?

913

---

What is the use of primary key?

953

---

Is not equal in sql?

960

---

What is nosql example?

971

---

Is join same as left join?

979

---

What are the different types of constraints?

1074

---

what is 'mysqladmin' in mysql? : Sql dba

974

---

If a cursor is open, how can we find in a pl/sql block?

1105

---

How to execute a stored procedure?

1036

---

what are the advantages of mysql in comparison to oracle? : Sql dba

942

---

How do I run sql?

1096

---

What is the purpose of design view?

952

---

What are the most important characteristics of pl/sql?

1080

---

Explain the difference between 'between' & 'and' operators in sql

948

---