Explain the general syntax for a SELECT statements covering
all the options.
- 3 Answers
- 6921 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
How to replace not in with not exist?
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.
What is dbms and its application?
Who are end users in dbms?
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
Explain about xml databases?
Explain about relational database management systems?
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?
What is the database development process?
Write the fastest query to find out how many rows exist in a table?
In which table collections errors are stored.
What are the three basic rules which are to be followed for the relational model of the database?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How long can an error message be in raiseerror function?
