what is the syntax of SELECT command?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle function?

600


What is oracle and what are its different editions?

581


Where do you use decode and case statements?

556


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

2598


Is there any function in oracle similar like group_concat of mysql?

541






When do you get a .pll extension in oracle?

679


What is rowid and rownum in oracle?

545


How can you merge two tables in oracle?

569


How to connect asp pages to oracle servers?

577


What is a database schema in oracle?

625


How to find the duplicate rows count from employees table in oracle?

554


How to define a procedure inside another procedure?

545


What is a Garbage Collection? and what is full recursive Garbage collection?

2389


What is oracle database 10g express edition?

599


What is a subquery?

614