Interested to Buy Any Domain ? << Click Here >> for more details...
explain query execution plan
- 1 Answers
- 4575 Views
- I also Faced
- E-Mail Answers
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.........
| Is This Answer Correct ? | 0 Yes | 2 No |
Define normalisation?
What are the differences between having and where clause.
what is mean by crystal repoart? ahere we will mainly use that?
What is the difference between sdf and mdf?
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
How to provide default values to function parameters?
Where cross join is used?
How can we solve concurrency problems?
What do you mean by normalisation?
Define outer join?
Should you normalize audio?
How to make remote connection in database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
