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
- 13644 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
How do I create an index in word?
Why cross join is used?
What is the difference between null value, zero, and blank space?
What are % type and % rowtype?
what is the difference between char_length and length? : Sql dba
What is a system versioned table?
What is compiled query?
How can we solve sql error: ora-00904: invalid identifier?
difference between anonymous blocks and sub-programs.
How do you write an index?
What is not in sql?
What is Difference Between Unique and Primary Key Constraints?
How to make a copy values from one column to another in sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
what is a composite primary key ? : Sql dba
