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 is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

991

---

How to test subquery results with the exists operator?

1107

---

What is equi join with example?

1136

---

what are acid properties? : Sql server database administration

1004

---

Explain some stored procedure creating best practices or guidelines?

941

---

What are Spatial data types in SQL Server 2008

1026

---

What is an execution plan? When would you use it?

981

---

Can an automatic recovery be initiated by a user?

1020

---

Define left outer join?

974

---

How can we improve performance by using SQL Server profiler?

1058

---

What is updatable resultset?

1013

---

How to use user defined functions in expressions?

1094

---

What is self contained sub query?

1066

---

What is the difference between truncate and delete commands?

1071

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

946

---