Answer Posted / v rajkumar

Select min(salary)FROM emp WHERE salary IN (SELECT distinct
TOP 2 salary FROM emp ORDER BY salary desc)
OR
Select top 1 salary from (select distinct top 2 salary from
emp order by salary desc) emp order by salary

OR
select max(salary) from emp where salary <(select max
(salary) from emp)

Can a cursor be updated? If yes, how you can protect which columns are updated?

1115

---

If a table does not have a unique index, can a cursor be opened on it?

916

---

What is system stored procedures?

1048

---

what is database replicaion? : Sql server database administration

1203

---

Explain log shipping?

1028

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1068

---

what is package and it uses and how can u call a package

2017

---

What happens if you are trying to access a schema not owned by you?

969

---

Can you force a query to use a specific index?

950

---

How to check status of stored procedure in sql server?

990

---

Explain the etl (extraction, transformation, and loading)?

1002

---

How do I view a script in sql server?

1047

---

What command is used to create a database in the sql server and how?

1186

---

How many cores do I need for sql server 2016?

905

---

What do you understand by sql server agent?

980

---