Write a query to find five highest salaries from EMP table. (there is a column SALARY)23 33717
What is meant by Join? What are the different types of Joins available? Explain.5 12518
How will you select unique values from a list of records?7 11505
How will you delete a particular row from a Table?7 10517
What is the difference between the Primary and Foreign key?7 11104
From an Employee table, how will you display the record which has a maximum salary?29 22678
What is nvl function?4 8636
what is 'force view'?3 12172
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?13 13555
what is global temporary tables and how use that tables in pl/sql packages1 7887
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.3 13047
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual6 13907
What are the steps you take to tune(performance tuning) the code in plsql?4 12382
I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.3 6766
which will default fire first statement level trigger or row level trigger2 5025
Let’s say you have several buttons that reuse the same onclick handler. How will you retrieve the name of the button that fired the event?
What is hover effect in css? How we can apply on tags?
What do you understand by java virtual machine?
You have a 100 coins laying flat on a table, each with a head side and a tail side. 10 of them are heads up, 90 are tails up. You can't feel, see or in any other way find out which side is up. Split the coins into two piles such that there are the same number of heads in each pile.
What is dynamic cursor in SQL SERVER?
Explain how HDFS communicates with Linux native file system?
List some key features in cakaphp 3 over cakephp2?
I have given ielts exam and i got 5.5 bands and i also got three I-20s from the US universities, so my ielts score will interrupt my visa or not? I want to confirm it.
What's c# ?
what is the difference between rectifier and converter and commudator?
Why would you use find and get rather than to obtain?
reason for difference in Balance sheet (Asset side & Liabilites side)
Hi evryone, Could you please suggest the best institute for SAP sd in ameerpet?
Can you explain what a photoshop lightroom?