Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 7964 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
Write the fastest query to find out how many rows exist in a table?
How to read and create .LDC data files which are used by linguatic dictionary.
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 what a database is?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain the rollup operator?
Explain about the relational database?
How is data stored in dbms?
Which data type cannot be used as a parameter in a udf?
Explain about the hierarchical model of the database?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about a primary key?
How to combine two function together?
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 fix a poorly performing query?
