Answer Posted / sandee saxena

-- Create table #temp
-- (
-- Emp_id int identity(1,1),
-- Emp_Name varchar (100) ,
-- Emp_Salary int
-- )

--
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('kunal', '2000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('aditya', '5000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('abhishek', '6000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('kailash', '5000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('rohit', '8000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('rakesh', '3000')

Select a.* From #temp a,
(Select Max(a.Emp_salary)Emp_Salary From #temp a,
(Select Max(x.Emp_salary)Emp_Salary From #temp a,
(Select a.* From #temp a,(Select Max (Emp_Salary)Emp_Salary
From #Temp) b
Where a.Emp_Salary < b.Emp_Salary ) x ) y
where a.Emp_Salary < y.Emp_Salary)Z
where a.Emp_Salary = z.Emp_Salary

What are different backups available in sql server?

1153

---

Explain important index characteristics?

1076

---

Define outer join?

1047

---

What is an index in a database?

1025

---

Is it possible in sql table to have more than one foreign key?

1092

---

How sql server executes a statement with nested subqueries?

1090

---

What is dbcc?

1179

---

Will count(column) include columns with null values in its count?

1148

---

What are the new features in sql server 2016?

1032

---

What are the types of ssrs?

149

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1298

---

What are basics of policy management?

1150

---

How to execute stored procedure and set temp table in sql server?

1091

---

what is denormalization? : Sql server database administration

973

---

What do you understand by SQL*Net?

1083

---