Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.........
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the new security features added in sql server 2014? : sql server security
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How to create a stored procedure with a statement block in ms sql server?
Can you explain full-text query in sql server?
What is database black box testing?
Define tempdb database?
What is Dependency Injection and provide example?
where the connection string store in the database
When would you use sql joins?
What is the use of =,==,=== operators?
What is policy based management (pbm)? : sql server database administration
Do you know what are the properties of the relational tables?
Explain unique key in sql server?
How to count duplicated values in a column in ms sql server?
How to use linked server?
