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
Does partitioning ssd reduce performance?
Delete duplicate rows without using rowid.
How retrieve field names from the table in SQL through JAVA code?
What are the steps to follow to configure SQL*Net?
What is the difference between a stored procedure and a user defined function?
What is the sql case statement used for? Explain with an example?
How to create new databases with "create database" statements?
What is the purpose of forms?
How to check status of stored procedure in sql server?
difference between Clustered index and non clustered index ?
What is a result set object returned by odbc_exec()?
How can we solve concurrency problems?
How would you use user_constraints table in DB?
What are scalar functions?
What is the datatype of rowid?
