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

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

I need to write this query without where clause.

Question Posted / shikhaagg

1 Answers
2529 Views
Alshaya, I also Faced
E-Mail Answers

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 all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers Pathway Technologies,

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers

3. Steps in UAT?

0 Answers Oracle,

What is Tax Categories?

0 Answers

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers Wipro,

whats the difference between join command and Cartesian product using example?

1 Answers

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers

how to write customizations in po

0 Answers Ernst Young,

how to create an user in oracle 10g.please give me an example..

1 Answers

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers Oracle,

what is different between inline query,subquery& corelated query?

8 Answers Quest,

What is the difference between oracle media recovery and crash recovery?

0 Answers

For more Oracle AllOther Interview Questions Click Here