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
Difference between negative and positive adjustments : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
What is the importance of batch source set up in ar? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is autocashrule set? : oracle accounts receivable
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
How would you determine who has added a row to a table?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is supporting issues GL AP and AR?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable