Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.
How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.
Latest Answer: Aggregation: Selecting the data in group of records is called aggregation.
There are five aggregate system functions they are viz. Sum, Min, Max, Avg, Count. They all have their own purpose Decomposition: Selecting all data without
any grouping ...
Latest Answer: View is mainly created to provide security for the data and data definitions.
Mainly used to retrieve the data in a secure manner.View cannot use space in the physical memory means virtually it will resides.
Join mainly used to join the data from ...
If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?
Is it possible to have primary key and foreign key in one table if yes so what is the use of foreign key?
Latest Answer: find the rowid for the duplicate row and delete the max id no keeping the min id. thats it... ...
What is the difference between IS and AS keyword in procedures,and also tell me the diff between Restricted and Unretsricted Procedure
View page [1] 2 Next >>
Go Top
