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 is an application role and explain a scenario when you would use one?

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,

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,

What is denormalization and when would you go for it?

9 Answers   NBP,

What is a database development?

0 Answers  

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

What are cursors? Explain different types of cursors?

6 Answers  

What is dbms explain in brief?

0 Answers  

What are the main phases of database development?

0 Answers  

explain detail about ftp in datastage?

0 Answers   IBM,

Explain about normal forms?

0 Answers  

What is the database development process?

0 Answers  

For more DB Development Interview Questions Click Here
Categories