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

Explain logical operators in sql server?

1052

---

Explain what is analysis service repository?

938

---

What is policy based management (pbm)? : sql server database administration

946

---

What is coalesce in sql server?

1009

---

How can you insert values in multiple rows using one Insert statement?

1054

---

How does using a separate hard drive for several database objects improves performance right away?

896

---

Can a database be shrunk with users active?

1080

---

How to list all columns in a table using odbc_columns()?

944

---

What is difference between sql and sql server?

948

---

What is a hint?

948

---

How to make a remote connection in a database?

939

---

How to set database to be read_only in ms sql server?

968

---

What are different types of replication in sql server?

1051

---

Where are SQL server users names and passwords are stored in sql server?

1219

---

how would you troubleshoot blocking? : Sql server database administration

954

---