Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

How many primary keys are possible in a table?

505

---

What is a database table?

505

---

Why transaction is important?

553

---

Is natural join and equi join same?

512

---

What are different types of join?

750

---

---

What happens if an integer is too big for int date type?

564

---

What are the different types of normalization?

605

---

What is nested transaction?

524

---

What is dynamic cursor in SQL SERVER?

555

---

How to insert stored procedure result into temporary table?

566

---

How to stop a loop early with break statements in ms sql server?

553

---

What are drillthrough reports?

100

---

What are exact numeric data types in ms sql server?

500

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

574

---

Give an example of SQL injection attack ?

561

---