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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you log an error to the server event log from a stored procedure?

556


Explain about the storage and physical database design?

529


What is DB Development software?

1612


How to customize error conditions.

1700


fact table and dimension table containg one to many relationship or many to one relastionship

2077






How to generate OIDS

1661


What are the key features of dbms?

564


Explain the cube operator?

597


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1783


Explain about relational database management systems?

568


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

587


How to use online Backups?

1725


Who are naive users?

605


What are the main phases of database development?

538


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

1583