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

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

how to write customizations in po

Differentiate between transaction type and transaction source? : oracle accounts receivable

what is the difference between TRUNCATE and DELETE command in SQL

how can we send a concurrent program output to the clients through mail or fax give me example.

How do you create a credit note against an invoice? : oracle accounts receivable

Explain prerequisites and post activities of oracle database installation

what are basic modules required to implement oracle application in any oraganisation?

You have just compiled a PL/SQL package but got errors, how would you view the errors?

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

deference between & and &&

Describe the P2P cycle ?

For more Oracle AllOther Interview Questions Click Here