SQL Query Interview Questions and Answers with Examples
Interview Questions on SQL are based on following two tables, Employee Table and Employee Incentive Table. Table Name : Employee EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT 1 John Abraham 1000000 01-JAN-13 12.00.00 AM Banking 2 Michael Clarke 800000 01-JAN-13 12.00.00 AM Insurance 3 Roy Thomas 700000 01-FEB-13 12.00.00 AM Banking 4 Tom Jose 600000 01-FEB-13 12.00.00 AM Insurance 5 Jerry Pinto 650000 01-FEB-13 12.00.00 AM Insurance 6 Philip Mathew 750000 01-JAN-13 12.00.00 AM Services 7 TestName1 123 650000 01-JAN-13 12.00.00 AM Services 8 TestName2 Lname% 600000 01-FEB-13 12.00.00 AM Insurance Table Name : Incentives EMPLOYEE_REF_ID INCENTIVE_DATE INCENTIVE_AMOUNT 1 01-FEB-13 5000 2 01-FEB-13 3000 3 01-FEB-13 4000 1 01-JAN-13 4500 2 01-JAN-13 3500 SQL Queries Interview Questions and Answers on "SQL Select" - Examples 1. Get all employee details from the employee table Select * from employee 2. Get First_N...
This comment has been removed by the author.
ReplyDeletewonderful
ReplyDeleteFear Sanjeet Sir plz tell me tally erp 9 book hindi & english in internet. plz mail me and reply me as soon or possible jarnail0@india.com.
ReplyDeletehttps://www.youtube.com/watch?v=Cp9F9MU47SI
Deletesee the video from this site
https://sites.google.com/site/gyanyagya2011/personal-page/tally-erp-9-tutorial-in-hindi
DeleteThanx a lot sanjay pandey....for correct link n support
ReplyDeleteFear Sanjeet Sir plz tell me tally erp 9 all taxation & payroll details hindi & english in internet. plz mail me and reply me as soon or possible spk5199@gmail.com.
ReplyDeleteThanks for sharing
ReplyDeleteWow! Great Post.! The content is very rich, and I really like it.
ReplyDeleteWow! Great Post.! The content is very rich, and I really like it.
ReplyDeletethank you for your interesting infomation.
ReplyDeletemystery thriller
Wonderful
ReplyDelete