how to write a query without using where?
Example- select * from employee where empno=10

I need to write this query without where clause.



how to write a query without using where? Example- select * from employee where empno=10 I need ..

Answer / 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

More Oracle AllOther Interview Questions

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  


can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,


What Are Cross Validation & Adi?

0 Answers   Oracle,


Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  


types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  


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?

7 Answers   TCS,


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?

2 Answers   CTS,


What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  


What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  


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.

1 Answers  


how to replace not in with not exist?

0 Answers   IBM,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)