Answer Posted / harshal

Below query is written assuming table "employee" has a column called "salary".
select salary from (select salary from (select distinct(salary) from employee order by salary desc)where rownum<n) order by salary asc where rownum<1;

Can we use where clause with group by?

904

---

what is the sql equivaent of the dataset relation object ?

2027

---

What languages bi uses to achieve the goal?

1002

---

What is field in algebra?

1038

---

What is key set driven?

963

---

What are different type of Collation Sensitivity?

1003

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1095

---

What is the usage of sign function?

1115

---

What is meant by indexing?

1022

---

What will be the maximum number of index per table?

1007

---

What is sql server agent and what are the two modes of authentication in sql server?

1058

---

Can we add our custom code in ssis?

990

---

ow to bring suspect mode datbase online from scratch

1806

---

What is an index in a database?

981

---

Explain what is the difference between a local and a global temporary table?

1005

---