Answer Posted / yash goyal

Select slary from
(select salary from empolyees
order by salary desc
where rownum<=&no.)
order by salary Asc
where rownum=1;

What is a data manipulation language?

1078

---

What are inner and outer joins examples of both?

1010

---

How is indexing done in search engines?

1023

---

how to rename an existing column in a table? : Sql dba

1084

---

What is linq to sql?

1181

---

What is anonymous block in sql?

1174

---

How many types of index are there?

1104

---

What is data type in sql?

1006

---

What is compiled query?

1089

---

What is difference between ms sql and mysql?

1016

---

what is innodb? : Sql dba

1173

---

What is the syntax to add a record to a table?

1152

---

Can you have more than one trigger on a table?

1047

---

Explain the working of primary key?

1155

---

Is a view faster than a stored procedure?

1013

---