Answer Posted / rathi

If we had a table named Employee which had a column named
Salary and we had to find the second highest Salary in the
Employee table, the query for the same would be:

SELECT TOP 1 Salary FROM (SELECT TOP 2 Salary FROM Employee
ORDER BY Salary DESC) AS E ORDER BY Salary ASC

The subquery or the inner query would return the top 2 rows
in descending Salary order which would be:
5000
4000
The outer query would then select the top 1 row from the
subquery results in ascending Salary order which would be:
4000

Explain the flow of creating a cube? : sql server analysis services, ssas

1100

---

Explain full-text query in sql server?

1054

---

How to insert and update data into a table with "insert" and "update" statements?

1042

---

How can we improve performance by using SQL Server profiler?

1108

---

What is difference between view and materialized view?

987

---

What is a rownum?

1059

---

What are the rendering extensions of ssrs?

160

---

Does sql server use t sql?

1071

---

How do you make a trace?

1073

---

What is the maximum size of a row in sql server?

1004

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1085

---

What is the usage of sign function?

1175

---

What is database replication?

1209

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2292

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1151

---