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
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
How would you determine who has added a row to a table?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
what are the API of GL,PO,AP
Why more redos are generated when the oracle database is in begin backup mode?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Explain the payment term in ar. : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
as a technical developer in oracle applications which type errors feced in your experience sofar
how to replace not in with not exist?
Explain about party and customer in ar : oracle accounts receivable
Explain the use of table functions.
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?