Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 8021 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 process of the user request and data generating?
What are data modelling techniques?
Can an extended stored procedure be called from inside a user-defined function?
Which data type cannot be used as a parameter in a udf?
How can you fix a poorly performing query?
Which four data types cannot be used as a return type from a user-defined function?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
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 relational operator join?
How is data stored in dbms?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain the cube operator?
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?
What are the three basic rules which are to be followed for the relational model of the database?
