Answer / vsubbaiah

Select Distinct |fields * | from table name
where condition
group by column list
having grouped column
order by column

Answer / poovitha

select * from employee

Here,
employee refers "TABLE NAME"
* refers all records in the table

Answer / chandiran

select <column name> from <table name>

Answer / sarika

select * from tablename;

Answer / shree

select field1,field2,.........field n
from table nane

Answer / mohammed ashfaq

SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn;
(IT IS SIMPLE SELECT)
(FOR COMPLEX SELECT)
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn
WHERE CONDITION;

what is the exact definition for pointer?

7 Answers   Wipro,

How would you extract DDL of a table without using a GUI tool?

1 Answers  

How to use group functions in the select clause using oracle?

0 Answers  

What is oracle datasource?

0 Answers  

How can we Update a table with out using UPDATE command?

1 Answers  

Explain what are synonyms used for?

0 Answers  

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  

After using set unused can we enable the column again to use? Please give me some answers....

1 Answers   Maveric,

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,

What do you mean by merge in oracle and how can you merge two tables?

0 Answers  

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,