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

How do I limit the number of rows returned by an oracle query after ordering?

1160

How to add a new column to an existing table in oracle?

1131

How to assign query results to variables?

1044

How to create a stored procedure in oracle?

1097

How to define a procedure inside another procedure?

1009

How to lock and unlock a user account in oracle?

1096

What is oracle used for?

1020

Write a syntax for update query in oracle?

1023

What happens to the current transaction if a ddl statement is executed?

1006

What are advantages of dateset in datastage?

2257

What is oracle host variable?

1049

Describe an oracle table?

1046

What privilege is needed for a user to connect to oracle server?

987

What happens to the indexes if a table is recovered?

989

How to assign a table row to a record variable?

1030