Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368110 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 / ruma
select *from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Differentiate pl/sql and sql?
What will you get by the cursor attribute sql%notfound?
What are transaction and its controls?
Can we insert data in view?
Is subquery faster than join?
What is sql character function?
What is file based approach?
How do I run a script in sql developer?
How are sql commands classified?
Are pl sql variables case sensitive?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How to connect a sql*plus session to an oracle server?
Where not exists in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How do I write a sql query in pgadmin 4?
