Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

I need to write this query without where clause.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1200


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

4438


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1038


What is the importance of batch source set up in ar? : oracle accounts receivable

1253


What Are Cross Validation & Adi?

1151


What is auto invoicing? : oracle accounts receivable

1150


What is supporting issues GL AP and AR?

2529


Where in the Oracle directory tree structure are audit traces placed?

2629


Can we modify approve purchase order?if yes what is navigation?

2002


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2850


what are the API of GL,PO,AP

2262


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2094


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2065


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

2202


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1122