retrieve the employee records whose sal is greater then the department avgsal by using antithetical function.
What is "anithetical function"?
Do you mean "analytic function"?
What have you tried? Post your best attempt. What was the problem with that code?
Are you using some commonly available table, such as scott.emp? If so, explain. If not, post CREATE TABLE and INSERT statements for a little sample data.
Either way, post the results you want from the given sample data.
Always say which version of Oracle you're using (for example, 220.127.116.11.0).
See the forum FAQ: https://forums.oracle.com/message/9362002
So, as people have said... what have you tried to do to solve this problem and what are you stuck on?
The volunteers of this forum are not just here to do your work for you. You have to show that you've at least had a go yourself, otherwise you won't learn anything.
And when you ask a question on these forums, make sure you include all the information that people will need to be able to help you...