Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 87699 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / mukesh
Second highest Value
select max(user_id) from users
where user_id < (select max (user_id) from users)
Mukesh Narayan SIngh
09873595976
mukeshnsingh22@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to use existing values in update statements using oracle?
What is integrity and what is constraint??Explain with example
Explain parameter file in oracle.
How do you find current date and time in oracle?
How to write text literals in oracle?
What are group functions in oracle?
Explain the types of exception?
Explain the difference between sql and oracle?
How to export data with a field delimiter?
What is a nested table and how is it different from a normal table?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to pass parameters to procedures?
What is a static data dictionary in oracle?
