Explain the general syntax for a SELECT statements covering
all the options.
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
What is dbms explain in brief?
State the acid rules?
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.
Explain what a database is?
Why does this query return 0?
Explain the role of indexing in 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?
In which database can extended stored procedures be added?
Explain about normal forms?
What is a database development?
Explain about relational operator join?
How to customize error conditions.
What are the key features of dbms?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What are the three types of database design?