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

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 / ananymous

Answer Posted / ananymous

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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.

2139

1. What is PO rate variance gain and loss?

2862

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2477

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2335

What is the difference between conversions and interfaces? : oracle accounts receivable

1148

What is mrc and what is its use? : oracle accounts receivable

1147

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2158

What is auto invoicing? Explain : oracle accounts receivable

1077

how to write customizations in po

1579

What is an Oracle database Full Backup?

1104

please send me oracle pl/sql exp resume. and also faqs...

2464

3. Steps in UAT?

2384

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2486

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4410

What is the sql query to find the employee who has Nth maximum salary?

5249