what is the syntax of SELECT command?

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

More Oracle General Interview Questions

What is a server parameter file in oracle?

0 Answers  


When do I need to use a semicolon vs a slash in oracle sql?

0 Answers  


How do you handle duplicate records in a database?

1 Answers  


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,


Can we store pictures in the database and if so, how it can be done?

0 Answers  


What is a nvl function?

0 Answers  


What is the sid in oracle?

0 Answers  


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  


How do I uninstall oracle 11g?

0 Answers  


What are different Oracle database objects?

1 Answers  


What is partitioned table in Oracle?

0 Answers   MCN Solutions,


What is the quickest way to export a table to a flat file?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)