select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

What are the differences between clustered and non-clustered index?

0 Answers  

---

What happens when converting big values to numeric data types?

0 Answers  

---

---

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What is resource db in sql server?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---