what is the syntax of SELECT command?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / ppp

6 Answers
8332 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the syntax of SELECT command?..

Answer / vsubbaiah

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

Is This Answer Correct ?

5 Yes

0 No

what is the syntax of SELECT command?..

Answer / poovitha

select * from employee

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

Is This Answer Correct ?

4 Yes

1 No

what is the syntax of SELECT command?..

Answer / chandiran

select <column name> from <table name>

Is This Answer Correct ?

3 Yes

1 No

what is the syntax of SELECT command?..

Answer / sarika

select * from tablename;

Is This Answer Correct ?

2 Yes

1 No

what is the syntax of SELECT command?..

Answer / shree

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

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of SELECT command?..

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;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer