Interested to Buy Any Domain ? << Click Here >> for more details...
what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
- 5 Answers
- 14771 Views
- HCL, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / anil kumar jaiswal
the sequence is like this :
select
from
table_name
where
group by
having
order by.
where ever writing a sql query the sequence should be in this order.
so the answer B is correct.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of non clustered index?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What normalization means?
How do you use join?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What are instead of triggers?
What is the default isolation level in sql server? : Transact sql
what are the differences between require and include, include_once and require_once? : Sql dba
what is union? : Sql dba
what is denormalization. : Sql dba
explain mysql aggregate functions. : Sql dba
List the ways to get the count of records in a table?
Is pl sql useful?
What are the different type of joins in sql?
What is sql analyzer?
