ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
 Categories >> Software >> Databases       
 
  Oracle (2020)   SQL Server (1065)   MS Access (23)   MySQL (194)   Postgre (6)
  Sybase (20)   DB Architecture (5)   DB Administration (212)   DB Development (53)   SQL PLSQL (754)
  Databases AllOther (105)
 
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task. business  0  4
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access Krishan  1  21
Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')  1  48
Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query. iNautix  0  30
how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.  0  21
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning? Accenture  0  36
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?  0  31
Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;  1  59
primary key is foreign key for the same table? oracle  0  53
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace????? genpact  0  45
how do see how much space is used and free in a tablespace genpact  0  53
what is tkprof tool and how it is used??? genpact  0  59
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product  1  179
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products  0  95
any body know about orawaves do they really provide placements in their unique placement program tcs  0  56
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 20   ... 39   ... 58   ... 77   ... 96   ... 115   ... 134   ... 153   ... 172   ... 191   ... 210   ... 229   ... 248   ... 267    Next
 
 
    Programming Languages Interview Questions     Scripts Interview Questions     Networking Interview Questions
    Microsoft Related Interview Questions     Databases Interview Questions     Operating Systems Interview Questions
    Testing Interview Questions     Servers Interview Questions     MainFrame Interview Questions
    Java Related Interview Questions     Middleware Interview Questions     Web Related Interview Questions
    Data Warehouse Interview Questions     HR Questions Interview Questions     Software Design Interview Questions
    Debugging Interview Questions     Version Control Interview Questions     Editors Interview Questions
    Telecom Interview Questions     ERP CRM Interview Questions     Embedded Systems Interview Questions
    Client Server Interview Questions     Artificial Intelligence Interview Questions     Cryptography Interview Questions
    EAI Interview Questions     Multimedia Interview Questions     Software Development Life Cycle Interview Questions
    Image Processing Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools? 852 TCS
What are advantages of dateset in datastage? 229 iGate
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards, 191  
Comment,Datatypes are unlimited 123 IBM
what ASIS BUSINESS PROCESS IN ORACLE FINANCE 358  
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000 392 Indian-Web-Technology
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement? 384  
Describe the Index, Types of index, At what situation we have used? Which one s better than others? 267 IBM
In oracle 10g export, import if we declare rows=y/n what would be the output? 462 Value-Labs
How to handle data if f table are more than one and each table contain thousands of entries? 122 QuickLogic
What is the exact use of Collections? 135  
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table... 265 Satyam
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com