Answer Posted / ashok naik

In Sql server:
Select top 1 ThirdHighest.salary from(
Select distinct top 3 salary from employee order by salary
desc) as ThirdHighest

--example for 4th highest salary in above query put 4
inplace of 3

--example for 5th highest salary in above query put 5
inplace of 3
--and so on for nth highest

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1976

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1066

---

How to convert raw data type into text in oracle? Explain

1047

---

How to create id with auto_increment on oracle?

1043

---

What is the Tune Query

2347

---

Explain integrity constraint?

1209

---

Explain the importance of .pll extension in oracle?

1061

---

What is raw datatype in oracle?

1210

---

What is not equal to in oracle?

1049

---

How to delete a column in an existing table in oracle?

1130

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

---

What is the max number of columns in an oracle table?

1048

---

What are the different oracle database objects?

1150

---

What is the relation of a user account and a schema?

1175

---

How do I manually create a database in oracle?

1070

---