What is the difference between join and union.
- 27 Answers
- 172875 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
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
Why select is used in sql?
What is sqlerrm?
Why do we use function in pl sql?
What is nvarchar max in sql?
What is a unique constraint?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
how to drop an existing index in mysql? : Sql dba
What is database migration?
What does seeding a database mean?
Write the alter statement to enable all the triggers on the t.students table.
Should I use mbr or gpt?
what are properties of a transaction? : Sql dba
Define the select into statement.
What are local and global Indexes and where they are useful.
How to select unique records from a table?
