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 myisam? : Sql dba

1077


What is exception? What are the types of exceptions?

1073


Why is nosql good?

1023


How do I run a pl sql procedure in sql developer?

968


How do you modify a trigger?

923


how to write date and time literals? : Sql dba

959


What is nosql db?

964


How do I kill a query in postgresql?

1110


How to display the records between two range in Oracle SQL Plus?

1144


Who developed sql?

1039


what are the advantages of mysql in comparison to oracle? : Sql dba

1000


How do I access sql anywhere database?

969


How do you rank data in sql?

1000


What is union and union all keyword in sql and what are their differences?

1100


Why use stored procedures?

1081