Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 6920 Views
- I also Faced
- E-Mail Answers
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
What is the database development process?
What is the maximum length of an extended property?
Explain about post-relational databases?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain the cube operator?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
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
How to generate OIDS
What are the key features of dbms?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How can I detect whether a given connection is blocked?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How can you log an error to the server event log from a stored procedure?
What are the 18 schemas?
How can you fix a poorly performing query?
