what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby

Answer Posted / abhishekjaiswal

It's Ans(b).

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between drop and truncate commands in sql?

530


Is sql difficult?

745


What company owns postgresql?

560


Explain the advantages and disadvantages of stored procedure?

649


Can we use pl sql in sql server?

538






What is set serveroutput on?

642


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

620


How exception is different from error?

540


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2069


What is sql procedures and functions?

531


What is date functions?

576


Can we create foreign key without primary key?

534


What information is needed to connect sql*plus an oracle server?

587


what is a field in a database ? : Sql dba

544


What is primary key secondary key alternate key candidate key?

544