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 |
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
What Are Cross Validation & Adi?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
types of receipts and detail desription about recipts and tables effected by receipts?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
how to replace not in with not exist?