1. Display all the rows and columns in the CLIENT table. Sort by client name in

1. Display all the rows and columns in the CLIENT table.
Sort by client name in reverse alphabetical order.

Question Posted / deepakgunji

2 Answers
6475 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetica..

Answer / k amit gupta

select * from emp order by ename desc

Is This Answer Correct ?

8 Yes

1 No

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetica..

Answer / yogesh sharma

select * from emp order by reverse(ename) ;

Is This Answer Correct ?

6 Yes

3 No

Post New Answer

More Oracle General Interview Questions

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers

when i run my query on yesterday it is fast but today it is slow why?

1 Answers

What is an Extent ?

3 Answers

what is pragma?

2 Answers

What are oracle functions?

0 Answers

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers Mind Tree,

How to delete a user account in oracle?

0 Answers

How to Select second Maximum salary in a Table ?

13 Answers Oracle,

Explain the use of owner option in exp command.

0 Answers

How to sort output in descending order in oracle?

0 Answers

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers Infosys,

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers Bravura Solutions, Cap Gemini,

For more Oracle General Interview Questions Click Here