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

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

Which data type cannot be used as a parameter in a udf?

0 Answers  

How can I detect whether a given connection is blocked?

0 Answers  

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

Explain about the hierarchical model of the database?

0 Answers  

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

what is Normalization?

6 Answers   TCS,

What is database design and development?

0 Answers  

Write the fastest query to find out how many rows exist in a table?

0 Answers  

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

Explain about normal forms?

0 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

For more DB Development Interview Questions Click Here
Categories