Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373172 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 / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 754 Yes | 97 No |
Post New Answer View All Answers
What are hotfixes and patches?
What is Materialized View? In What Scenario we Use Materialized View?
Can we enter data in a table in design view?
What kind of join is join?
What is the difference between a query and a report?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Show the cursor attributes of pl/sql.
what is a primary key? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
what is union, minus and interact commands? : Sql dba
What is data control language?
Can cursors be part of a trigger body?
How many parts of a pl sql block are optional?
Does postgresql run on the cloud?
Can you sum a count in sql?
