what is the syntax of SELECT command?
Answers were Sorted based on User's Feedback
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 |
Answer / poovitha
select * from employee
Here,
employee refers "TABLE NAME"
* refers all records in the table
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / shree
select field1,field2,.........field n
from table nane
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
What is a server parameter file in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How do you handle duplicate records in a database?
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.
Can we store pictures in the database and if so, how it can be done?
What is a nvl function?
What is the sid in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How do I uninstall oracle 11g?
What are different Oracle database objects?
What is partitioned table in Oracle?
What is the quickest way to export a table to a flat file?