Answer Posted / rabi

SELECT A.SAL
FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
WHERE A.SAL<=B.SAL);

How do I create a partition table in sql server?

1049

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

955

---

What is named query? : sql server analysis services, ssas

909

---

What is data mart? : sql server analysis services, ssas

1005

---

How can we rewrite sub-queries into simple select statements or with joins?

925

---

Explain syntax for dropping triggers?

887

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

989

---

How will you add a dimension to cube? : sql server analysis services, ssas

1013

---

What is the difference between a "where" clause and a "having" clause?

1118

---

What is the difference between upgrade and migration in sql server?

1026

---

How will you find out if there are expensive SQL statements running or not?

969

---

What command would you use to create an index?

984

---

What are different types of table joins?

964

---

What are the steps you must follow to hide sql server instances?

931

---

Write an sql query to find first weekday of the month?

867

---