i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

How we can compare two database data?

0 Answers  

---

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

0 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

What is openrowset sql server?

0 Answers  

---

How to create an inline table-valued function?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---