Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 8170 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
In which table collections errors are stored.
What is the maximum length of an extended property?
How you can make a parameterized view?
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
What are the three basic rules which are to be followed for the relational model of the database?
How can I detect whether a given connection is blocked?
What are the types of database model?
Where is dbms used?
Explain what a database is?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Write the fastest query to find out how many rows exist in a table?
Explain about relational database management systems?
Explain about the hierarchical model of the database?
