What is the difference between join and union.
Answer Posted / krish
how to fine top 3 emp(sal) from each deptno
i want the out put like this
sal deptno
100 20
200 20
300 20
150 30
250 30
350 30
so top 3 from each dept
thank u
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How insert into statements in sql?
What are transaction and its controls?
Is sqlite good enough for production?
What is clustered index sql?
What is the most restrictive isolation level? : Transact sql
Which one is faster ienumerable or iqueryable?
What is the difference between pl and sql?
What are the two types of periodical indexes?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Define implicit and explicit cursors.
Should I use mbr or gpt?
The select into statement is most often used to create backup copies of tables or for archiving records?
What are the different types of constraints?
What does data normalization mean?
what is a constraint? : Sql dba