How to Remove the 3rd highest salary person record from table?9 11487
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?6 4218
what is the difference between table and veiw?4 4437
Which Department has MOST NUMBER of employees?8 38989
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?1 2469
how to retrive xml data for using sql query?3 4698
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?1 3221
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.1284
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));779
What is the importance of implementing a fault tolerance system? Are there limitations?
What are the j2ee technologies?
what is the effect of connecting three phase supply lines to three phase auto transformer output terminals through a fuse of 10Amp and a circuit breaker (MCB). Is this connection permanently destroy the transformer?
Ram, the proprietor brought additional capital of Rs 75000/- by pledging his wifes gold.pass entry
Dear friends I want to design busbar for1600 kva transformer(i.e2100 amps) what are all the factors to be considered before selectinga busbar what are all the standard sizes of busbars what is the formula for finding current of copper and aluminium busbar
What is a feasibility study?
Explain software testing strategies?
How do I reset my file format?
What is the xml datatype?
define voltage regulator.
What is method overloading with type promotion?
Explain what are the rules that you have to follow for wordpress plugin development?
What are the most important topics in java?
Are logs also saved during a database backup?
What is meant by pulse triggered devices?