Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 8096 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
In which database can extended stored procedures be added?
How long can an error message be in raiseerror function?
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 about the relational database?
In which table collections errors are stored.
Which four data types cannot be used as a return type from a user-defined function?
What is an application role and explain a scenario when you would use one?
What is the database development process?
Can an extended stored procedure be called from inside a user-defined function?
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?
How would you design a database for an online site, which would average a million hits a day?
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?
How is data stored in dbms?
Explain about relational operator join?
How to generate OIDS
