Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

What is replication id?

921


What is oracle sql called?

902


What is acid property in a database?

1016


What are instead of triggers?

1028


How do I edit a stored procedure?

978


What is pivot table in sql?

1081


how to use in conditions? : Sql dba

992


What problem one might face while writing log information to a data-base table in pl/sql?

1133


which types of join is used in sql widely? : Sql dba

966


How you improve the performance of sql*loader? : aql loader

997


What is primary key in db?

991


how to drop an existing index in mysql? : Sql dba

1052


How can you save or place your msg in a table?

985


Can we use pl sql in mysql?

995


How to handle bulk data?

1298