Interested to Buy Any Domain ? << Click Here >> for more details...
determine the minimum salary of the employee and his details
who join on the same date
- 3 Answers
- 6066 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
do not quite understand the question -- mininum sal of the
employees who have the same join dates (partition by
hiredates), or the one employee with min sal.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ns
select min(salary) from (select salary from employees where
hire_date = '21-JUN-99');
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / naresh
select min(sal) from (select sal from emp e1,emp e2 having
e1.hiredate=e2.hiredate);
| Is This Answer Correct ? | 1 Yes | 3 No |
What do you mean by checkpoints in dbms?
What are views in dbms?
Is there an example how to configure externalfileaccess setting in firebird.conf?
How to open the database in exclusive mode?
What is difference between database and website?
What is difference between database and file?
What is the purpose of a database table?
Describe and contrast sql and qbe.
What is Full Backup ?
What are queries in dbms?
What is service based database?
What are the functions of rdbms?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
