SQL Interview Questions
SQL Interview Questions Q. Display names of all salesperson whose customers are john? Q. Display names of all salesperson whose customers are not john? Q. Insert those records into a table highvale(name,age) from saleperson whose salary is 2000 or greater than ? Q. Display name of customer who have 2 or more order ? Q. Display name of saleperson who have maximum amt in orders ? Q. Display name of saleperson,total of amt who have maximum amt in orders ? Q. Display 3 rd highest salary of salesperson (Assume there are 1000 records in salesperson table). Q. Difference between Delete and Truncate ? Q. Select substr(‘shubh’,2) from dual ? Is this Query will run ? yes /No .If not then what will be correct Query ? Q. Select Round(2.75,2) from dual, Select trunc(2.75,2) from dual ? what will be output ? Q. Difference between CAST and Convert ? (note : both function may be or may be not in your database.So try it