Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361379 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 / atheeq
select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
what are the features and advantages of object-oriented programming? : Sql dba
explain the difference between delete , truncate and drop commands? : Sql dba
Can ddl statements be used in pl/sql?
What is trigger in sql?
what is the difference between undefined value and null value? : Sql dba
What is varchar example?
How to check if a column is nullable before setting to nullable?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How do I add a database to sql?
How to download oracle sql developer?
What is on delete set null?
Mention what pl/sql package consists of?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What version is sql?
What does the sign mean in sql?
