Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 369144 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 / barochia dharmesh
You should use rank query with order by and give where your
search criteria.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does partition by mean in sql?
What are the sql versions?
What is data definition language?
Can we change the table name in sql?
what is bcp? When is it used?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How does rowid help in running a query faster?
What is the difference between an inner and outer join?
define join and explain different type of joins? : Sql dba
what are all the common sql function? : Sql dba
Is join same as left join?
Is sql a microsoft product?
What is dml and ddl?
How do I install sql?
What is a pragma statement?
