Answer Posted / lakshmi narayanan r

CREATE TABLE bikes (bikeID INT, CName VARCHAR(50), BNAME
VARCHAR(50))

INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Shyam', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Jaya', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Deepa', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('vasu', 'car')


;WITH tmp (RowId, CName) AS (SELECT ROW_NUMBER() OVER
(PARTITION BY CName ORDER BY BikeID ASC) AS RowId, CName
FROM Bikes)
SELECT DISTINCT CName FROM tmp WHERE RowId > 1

What new changes are being made in SQL Server?

1195

---

Find first and last day of current month in sql server

1028

---

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?

1073

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1138

---

What are user-defined functions (udfs) in sql server?

993

---

How to provide login information for a new odbc dsn?

1052

---

Tell me about normalization in DBMS.

998

---

What is key set driven?

963

---

how to create “alternate row colour”?

146

---

What languages bi uses to achieve the goal?

1002

---

Can coalesce return null?

1021

---

What is join and name different type of joins?

1051

---

How many replicas are maintained for each sql azure db?

124

---

How can you manage sql azure security?

103

---

What is a user-defined function in the sql server and what is its advantage?

1105

---