Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367636 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 / jat16may
SELECT MAX(SALARY) FROM TABLENAME WHERE SALARY<(SELECT
MAX(SALARY) FROM TABLE NAME
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are sql built in functions?
what is bdb (berkeleydb)? : Sql dba
How is data stored on a disk?
What is snowflake sql?
Why are aggregate functions called so?
How does postgresql compare to "nosql"?
How do you modify a trigger?
Does access use sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How do I view output in sql developer?
which operator is used in query for pattern matching? : Sql dba
Is primary key clustered or nonclustered?
what are the differences between require and include, include_once and require_once? : Sql dba
How do you explain an index?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
