Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367465 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 / jude
first find first maximum
then easy to find second maximum
| Is This Answer Correct ? | 98 Yes | 330 No |
Post New Answer View All Answers
what is difference between delete and truncate commands? : Sql dba
What does trigger mean in slang?
Why do we use sqlite?
what is sql server agent? : Sql dba
How do you declare a variable in pl sql?
Is pl sql a programming language?
Do foreign keys improve performance?
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
How to connect a sql*plus session to an oracle server?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is parallel hint?
How to avoid using cursors?
What is sql injection owasp?
Which query operators in sql is used for pattern matching?
What are the types of join and explain each?
