Interested to Buy Any Domain ? << Click Here >> for more details...
From an Employee table, how will you display the record
which has a maximum salary?
- 29 Answers
- 38995 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / apsar
select * from (select e.* from emp order by e.sal desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql and its types?
How can get second highest salary in sql?
What is sql partition?
What are all ddl commands?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what are the differences between char and varchar? : Sql dba
What is cursor in pl sql?
what are the types of subquery? : Sql dba
What is a data manipulation language?
What is a primary key example?
What are different clauses used in sql?
what is a tablespace? : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
how to do backup entire database? : Transact sql
What is spool?
