Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367613 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 / bipin
use this query. it works great.
select max(sal) from table_name where sal<(select max(sal)
from table_name)
| Is This Answer Correct ? | 415 Yes | 59 No |
Post New Answer View All Answers
Which is faster joins or subqueries?
Is sql difficult?
How many triggers can be applied to a table?
What are local and global variables and their differences?
Are sql database names case sensitive?
Can we use update in sql function?
What is foreign key and example?
How many functions are there in sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
what is the command line end user interface - mysql? : Sql dba
Can two tables have same primary key?
How does join work in sql?
What is use of trigger?
Which nosql database is best?
What is dbo in sql?
