Select Distinct |fields * | from table name where condition group by col

what is the syntax of SELECT command?

Question Posted / vsubbaiah

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the difference between data migration and production migration.

2275

How to run queries on external tables?

988

How to get a list of all user accounts in the database?

1032

How to check the oracle tns settings?

990

Use of an integrity constraint is better to validate data. Explain

974

How to count duplicated values in a column in oracle?

982

What is the difference between substr and instr?

977

How to use like conditions in oracle?

994

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2209

List out the types of joins.

1080

How to use "in out" parameter properly?

998

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995

How to get the Installed Oracle Version Information ?

1073

How to view existing locks on the database?

994

What is oracle instant client?

970