explain query execution plan
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 |
How to assign new column names in a view?
what is the disadvantage of SQL Loder?
What do you mean by subquery?
How secure is sql server database?
How to create a Master database in SQL server ?
What function does a database engine serve in the sql server?
How do I compare two values when one value(data type) is char and the other is an integer?
How to connect a database with sql express.?
Do you know how to store and query spatial data?
where the connection string store in the database
Explain time data type in sal server 2008?
What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
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)