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...

  1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

Explain the general syntax for a SELECT statements covering
all the options.

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain the general syntax for a SELECT statements covering all the options...

Answer / us

SELECT select_list

[INTO new_table_]

FROM table_source

[WHERE search_condition]

[GROUP BY group_by_expression]

[HAVING search_condition]

[ORDER BY order_expression [ASC | DESC]

Is This Answer Correct ?    12 Yes 1 No

Explain the general syntax for a SELECT statements covering all the options...

Answer / rosemary masha

select* from table name
where last name='Faina'

Is This Answer Correct ?    1 Yes 1 No

Explain the general syntax for a SELECT statements covering all the options...

Answer / dinesh sharma

select * from tablename(select all fields of the tables)
select f1,f2 from tablename (select selected fields(like
f1,f2)
select f1,f2,2 [f3] from tablename(select selected fields
plus one fields having default value is 2)

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More DB Development Interview Questions

What are cursors? Explain different types of cursors?

6 Answers  

Who are naive users?

0 Answers  

What are the types of database model?

0 Answers  

In which table collections errors are stored.

0 Answers  

Write short notes on manual refreshes.

0 Answers  

How to generate OIDS

0 Answers  

how to find the first two highest salaries in deptno in emp table

2 Answers  

Explain about xml databases?

0 Answers  

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

Write the difference between case version and decode version.

2 Answers  

For more DB Development Interview Questions Click Here
Categories