Answer / pravati

In two ways we can use count
1. SELECT COUNT(*) FROM table name.
2.SELECT COUNT(DISTINCT *) from table name.

Answer / krishna

select count(1) from table name

how do u find least salary in a table

4 Answers  

---

What is an identity?

0 Answers  

---

What are scalar functions?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---

query processing

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

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  

---

What is isolation levels?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---