Display names and numbers of employees who have 5 years or more experience and salary less than Rs.15000 using array of structures (name, number, experience and salary)



Display names and numbers of employees who have 5 years or more experience and salary less than Rs.1..

Answer / un educator

Select name ,sysdate - joindate as exp,salary from employer where sysdate -joindate=5 and salary <15000

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More C Interview Questions

a single linked list consists of nodes a to z .print the nodes in reverse order from z to a using recursion

0 Answers   Mindteck,


How can I invoke another program (a standalone executable, or an operating system command) from within a c program?

0 Answers  


What 'lex' does?

0 Answers   Tech Mahindra,


What's the best way of making my program efficient?

0 Answers   Celstream,


what is pointer ? what is the use of pointer?

6 Answers   Infosys,






a sequence of bytes with one to one corrspondence to those in the external device a) sequential addressing b) address c) byte code d) none

0 Answers  


What does dm mean sexually?

0 Answers  


What are header files and what are its uses in C programming?

0 Answers  


What is the difference between functions getch() and getche()?

0 Answers  


Is it better to use a macro or a function?

0 Answers  


What is string concatenation in c?

0 Answers  


#include main() { int i=1,j=2; switch(i) { case 1: printf("GOOD"); break; case j: printf("BAD"); break; } }

6 Answers   ME,


Categories