Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on two a's within the SQL forums, part of the Databases category; 1.Display all the employee details whose name consists of two 'A's 2.check whether all the employee numbers are indeed unique List the no. of clerks, no. of managers department wise ...
|
|||||||
|
|||
|
two a's
1.Display all the employee details whose name consists of two 'A's
2.check whether all the employee numbers are indeed unique List the no. of clerks, no. of managers department wise if both no. of clerks and no. of managers are >2 3. in which year most of the employees were joined in the company. diaplay the year and the no. of employees. 4. display the average, monthly bill for each job type within a dept 5. show the average salary for all departments employing more than 3 people |
| The Following User Says Thank You to shameem_chandu For This Useful Post: | ||
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|