Answer Posted / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

List out the difference between union and union all in sql server?

1043

---

What is sql or structured query language?

1201

---

What is set nocount on?

995

---

What is clustered index

1061

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1026

---

What are distributed partitioned views?

1137

---

Which sql server table is used to hold the stored procedure scripts?

1111

---

What command is used to create a database in the sql server and how?

1243

---

Write an SQL query to obtain the 2nd highest salary.

1126

---

Does partitioning improve performance sql server?

1032

---

What are Spatial data types in SQL Server 2008

1073

---

How to execute stored procedure and set temp table in sql server?

1101

---

Define Unique Key?

1069

---

What are the advantages of using third-party tools?

1038

---

Can binary strings be used in arithmetical operations?

986

---