Answer / sush4

CREATE TABLE YourTable
(
ID INT,
PlateNo INT,
[Type] VARCHAR(20),
[Image Name] VARCHAR(20)
);

INSERT INTO YourTable
VALUES
(27,455,'User','img1.jpg'),
(32,542,'Alternative','img2.jpg');
SELECT * FROM YourTable

;WITH Cte AS
(SELECT T.*,T2.PlateNo PlateNo2, T2.Type Type2, T2.[Image Name] [Image Name 2] FROM YourTable T JOIN YourTable T2 ON T.ID<>T2.ID)
UPDATE Cte SET PlateNo = PlateNo2, Type=Type2,[Image Name]=[Image Name 2]


SELECT * FROM YourTable

DROP TABLE YourTable

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

What is intellisense?

0 Answers  

---

What is a system database and what is a user database?

0 Answers  

---

What is a livelock?

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

What are dml triggers and types of dml triggers?

0 Answers  

---

How to use user defined functions in expressions?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

Explain linked server in sql?

0 Answers  

---