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 the use of transaction flexfield in autoinvoice? : oracle accounts receivable

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

what is correlated subquery

Explain an ORA-01555

Describe what redo logs are.

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

How would you go about increasing the buffer cache hit ratio?

what is difference between inner join & nested query or subqueries

what is the difference between TRUNCATE and DELETE command in SQL

What is Tax Categories?

For more Oracle AllOther Interview Questions Click Here