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 parallel hint?

1239


What is a primary key? Explain

934


What are variables in pl sql?

1116


How to create a menu in sqlplus or pl/sql?

1082


How do I view a view in sql?

902


what are the types of join and explain each? : Sql dba

1006


what is clause? : Sql dba

1013


How do you change a value in sql?

979


what are sequences

1669


What is a primary key sql?

1012


Can we use pl sql in mysql?

973


How can use stored procedures in sql?

1100


How to add, remove, modify users using sql?

1000


How do you bind variables in pl sql?

1052


How does a trigger work?

1003