how to write a query without using where? Example- select * from employee where

how to write a query without using where?
Example- select * from employee where empno=10

I need to write this query without where clause.

Question Posted / shikhaagg

how to write a query without using where? Example- select * from employee where empno=10 I need ..

Answer / ananymous

Select empid,empname,sal from emp group by empid,ename,sal
having empid = 10

Is This Answer Correct ?

2 Yes

1 No

More Oracle AllOther Interview Questions

what is diff between pre insert,on insert,post insert triggers?

Explain prerequisites and post activities of oracle database installation

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

what are the API of GL,PO,AP

what is the difference between TRUNCATE and DELETE command in SQL

What Are Cross Validation & Adi?

what is sql*loader parameters and where we will use it.

What is Tax Categories?

Explain about party and customer in ar : oracle accounts receivable

difference of using cursor for loop and open,fetch,close.which one is better

Could you please let me know the interfaces in OM / FA??

For more Oracle AllOther Interview Questions Click Here