Answer Posted / sujitpingale

Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);

Enter value in inputbox. If you enter 1 then it will give
highest salary

What are crud methods?

1084

---

How do you get column names only for a table (sql server)?

1212

---

What does rownum mean in sql?

1089

---

How do you declare a variable in pl sql?

1069

---

what are the authentication modes in sql server? : Sql dba

1118

---

What is an intersect?

1156

---

Is sql free?

1024

---

What is normalisation in sql?

1098

---

How do you create an update query?

1020

---

How many tables can you join in sql?

1006

---

Is primary key a clustered index?

1008

---

Explain what is sql?

1180

---

What is pls_integer in pl sql?

1157

---

What does select top 1 do in sql?

1140

---

What is the primary use of normalization?

1053

---