Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116004 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / wei
The best answer should be the first one, this is because
the sql statement accesses table emp only once.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
Whis is not false in primary key?
What do you mean by field in sql?
What has stored procedures in sql and how we can use it?
What is a schema sql?
Is sql scripting language?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Is coalesce faster than isnull?
How to write html code in pl sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
how to select unique records from a table? : Sql dba
State some properties of relational databases?
What is the difference between inner join and outer join?
Why select is used in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What is the left table in sql?
