Answer / nikhila reddy

6. select top,ditinct,aggregations
steps to execute a query

1. from table1 joins table2
2. on condition
3. where condition
4. group by condition
5. having condition
7. orderby

these way we write the query,
while executing a query internally itwill puul data from table 1 and placed in temp1 as same table2 into temp2
result in temp3.then it checks where conditon and place in temp4 so on.........

Explain transaction server consistency?

0 Answers  

---

What are the two modes of authentication in sql server?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

How to rebuild master databse?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

What is sql server replication? : sql server replication

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

Explain about Joins?

0 Answers   Infosys,

---