Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361347 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / pramod sharma
select f_name max(salary)from emp,dep
where salary<(select max(salary)from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What packages are available to pl/sql developers?
Can sql developer connect to db2?
Why we use cross join?
How do I truncate a word?
What is sql table?
How do you concatenate in sql?
What is scalar and vector?
what is cursor. write example of it. What are the attributes of cursor.
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How do you respond to dementia behavior?
how to see the create table statement of an existing table? : Sql dba
Can we use the cursor's to create the collection in PL/SQL?
what is a control file ? : Sql dba
What is a common use of group by in sql?
What is pl sql in oracle?
