How to Remove the 3rd highest salary person record from table?9 12871
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 4653
what is the difference between table and veiw?4 4803
Which Department has MOST NUMBER of employees?8 42359
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 2678
how to retrive xml data for using sql query?3 5040
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 3412
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.1401
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'));887
How might you demonstrate your presentation online in powerpoint?
Hello sir, I am Rajaram. I have finished DME (Diploma in Mechanical Engineering). I would like to attend BHEL supervisor examination. So i want which type of questions can i prepare. & give previous supervisor examinations questions. Reply my mail (firstname.lastname@example.org)
how you can run CQL commands in Neo4j?
Which one of the following peoplecode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
When will you use nsarray and nsmutablearray?
How many types of assembly languages are there?
Tell me about your Service level Agreement (SLA) for different Priorities of different tickets levels? I have an interview in immediate future so plzz help me...Please reply asap... Urgent!!!! Waiting for your response eagerly... Thanks in advance
What is the default value of session attribute in jsp?
What is page layout in salesforce?
When is the arraystoreexception thrown?
c programs are converted into machine language with the help of a) an interpreter b) a compiler c) an operatinf system d) none of the above
What is session in php why it is use?
List down some of the methods in a react-dom package
Why is the spark so fast?
Rewrite the command to print the sentence and convert the variable to plural: echo “i like $variable”.