Answer Posted / santosh kumar

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

How to create a large table with random data for index testing in ms sql server?

525

---

What is the order in which the sql query is executed?

513

---

Explain the difference between HTTP and HTTPS in database?

553

---

Define ACID properties in a Database?

616

---

what's the difference between delete table and truncate table commands? : Sql server database administration

475

---

---

What do you understand by SQL*Net?

607

---

What is the order by used for?

611

---

how would you store your query in an SSRS report or a Database server?

116

---

Are resultset updatable?

520

---

What is report rendering ?

102

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

495

---

what's new in sql server 2016?

552

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

525

---

What is a partition function in sql server?

529

---

What is sql profiler. What are the default templates with it? : sql server database administration

513

---