Answer Posted / anil kumar prajapati

CREATE TABLE Employee_Test
(
Employee_ID INT,
Employee_name Varchar(100),
Employee_Salary Decimal (10,2)
);
INSERT INTO Employee_Test VALUES (1,'Anish',1000);
INSERT INTO Employee_Test VALUES (2,'Sushant',1200);
INSERT INTO Employee_Test VALUES (3,'Rakesh',1100);
INSERT INTO Employee_Test VALUES (4,'Manoj',1300);
INSERT INTO Employee_Test VALUES (5,'Amit',1400);
INSERT INTO Employee_Test VALUES (6,'Lokesh',1600);
INSERT INTO Employee_Test VALUES (7,'Maneneder',1400);
INSERT INTO Employee_Test VALUES (8,'Narendra',400);
INSERT INTO Employee_Test VALUES (9,'Kaushal',1900);
INSERT INTO Employee_Test VALUES (10,'Vikas',3400);
INSERT INTO Employee_Test VALUES (11,'Sudhir',800);
SELECT *FROM Employee_Test Emp1
WHERE ( n ) = (SELECT COUNT( DISTINCT (Emp2.Employee_Salary
) )
FROM Employee_Test Emp
WHERE Emp2.Employee_Salary >= Emp1.Employee_Salary
)

explain databases and sql server databases architecture? : Sql server database administration

1015

---

How to create a scrollable cursor with the scroll option?

1050

---

What is the default Port No on which SQL Server listens?

1177

---

What are the differences between triggers and stored procedures?

1119

---

Tell me what is difference between view and materialized view?

985

---

How raid can influence database performance?

1087

---

Disadvantages of the indexes?

1184

---

Define union, union all, minus, intersect?

1035

---

List the types of recovery model available in sql server?

971

---

What authentication modes does sql server support?

1153

---

What is ms sql server index?

1152

---

How do database indexes work?

1058

---

What is openrowset sql server?

1193

---

Why should we go for stored procedures? Why not direct queries?

1157

---

How to bind a view to the schema of the underlying tables?

1048

---