Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 8282 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
Explain the role of indexing in databases?
What is a database development?
What is dbms and its application?
In which table collections errors are stored.
Explain about post-relational databases?
State the acid rules?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
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).
Why does this query return 0?
Explain about a primary key?
How can you log an error to the server event log from a stored procedure?
How to use online Backups?
How would you design a database for an online site, which would average a million hits a day?
Explain about xml databases?
What are the three types of database design?
