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 / ananymous
Select empid,empname,sal from emp group by empid,ename,sal
having empid = 10
| Is This Answer Correct ? | 2 Yes | 1 No |
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
When creating a user, what permissions must you grant to allow them to connect to the database?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
What is an Oracle database Partial Backup?
can u give guidance abt packages of plsql
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
What is Tax Categories?
What view would you use to determine free space in a tablespace?
Give two examples of referential integrity constraints.