what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
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 replication id?
What is oracle sql called?
What is acid property in a database?
What are instead of triggers?
How do I edit a stored procedure?
What is pivot table in sql?
how to use in conditions? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
which types of join is used in sql widely? : Sql dba
How you improve the performance of sql*loader? : aql loader
What is primary key in db?
how to drop an existing index in mysql? : Sql dba
How can you save or place your msg in a table?
Can we use pl sql in mysql?
How to handle bulk data?