Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
- 5 Answers
- 10630 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
Answer Posted / guest
select *from emp where max(sal)=dept;
| Is This Answer Correct ? | 2 Yes | 16 No |
Post New Answer View All Answers
How to assign query results to variables?
What is ADDM Advisor in Oracle?
What is Library Cache in Oracle?
Difference between inner join vs where ?
What is oracle server autotrace in oracle?
What are the extensions used by oracle reports?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How do you store pictures in a database?
How to specify default values in insert statement using oracle?
if you ctreate table identity
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is key preserved table?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to establish administrator authentication to the server?
What are a cluster and non-cluster index?
