Answer Posted / jyoti

CREATE TABLE #CustDetails
(
CustID INT IDENTITY(1,1),
CustName VARCHAR(10),
City VARCHAR(10)
)

INSERT INTO #CustDetails
SELECT 'A1','Pune' UNION ALL
SELECT 'A2','Pune' UNION ALL
SELECT 'A3','Pune' UNION ALL
SELECT 'A4','Pune' UNION ALL
SELECT 'A5','Pune' UNION ALL
SELECT 'A6','Pune' UNION ALL
SELECT 'B1','Delhi' UNION ALL
SELECT 'B2','Delhi' UNION ALL
SELECT 'B3','Delhi' UNION ALL
SELECT 'B4','Delhi' UNION ALL
SELECT 'B5','Delhi' UNION ALL
SELECT 'B6','Delhi' UNION ALL
SELECT 'B7','Delhi' UNION ALL
SELECT 'B8','Delhi' UNION ALL
SELECT 'C1','Mumbai' UNION ALL
SELECT 'C2','Mumbai' UNION ALL
SELECT 'C3','Mumbai' UNION ALL
SELECT 'C4','Mumbai' UNION ALL
SELECT 'C5','Mumbai'

SELECT
ID,CustName,City
FROM
(
SELECT
ROW_NUMBER() OVER (PARTITION BY CITY ORDER
BY CustID DESC) ID,CustName,City
FROM
#CustDetails AS CD1
) A
WHERE A.ID < 3

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2077

---

explain different types of constraints? : Sql server database administration

1004

---

Do you know what are the steps to process a single select statement?

1020

---

How to maintain a fill factor in existing indexes?

1057

---

Define ACID properties in a Database?

1106

---

Explain primary key in sql server?

1075

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1112

---

Can we insert data if clustered index is disabled?

989

---

How to receive output values from stored procedures?

1237

---

What is database replication?

1210

---

How do I delete a sql server database?

1100

---

How would you add a section to a table?

1113

---

How do you improve the performance of a SQL Azure Database?

137

---

Can we use pragma autonomous_transaction in trigger?

1015

---

What is sql collation?

1271

---