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 interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
Can we modify approve purchase order?if yes what is navigation?
how to replace not in with not exist?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
i want to know about the javaBean.what is its purpose and how it can use in Forms.
1. What is PO rate variance gain and loss?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
default triggers available for reports
What is the mandatory setup in cyclecount ?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is the difference between oracle media recovery and crash recovery?
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
What is the sql query to find the employee who has Nth maximum salary?