Answer / anjaligarg

First we declare is as primary key and after group by we can get uniqu values.

CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (ID)
);

SELECT ID, LastName,FirstName
FROM Persons
GROUP BY ID, LastName,FirstName;

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What is rank function?

0 Answers  

---

Explain transaction server isolation?

0 Answers  

---

What are the advantages of paper records?

0 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

How to set database to be single_user in ms sql server?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---