ALLInterview.com :: Home Page KalAajKal.com
 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                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Databases >> Postgre
 
 


 

Back to Questions Page
 
Question
	

how to find nth lowest salary
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
For All SQL , Tested in PostgresSQL  : Javedcc@gmail.com

SELECT * FROM <Table_Name> A
WHERE N = (SELECT COUNT(DISTINCT B.Column_Name ) FROM
<Table_Name> B WHERE A.Column_Name >= B.Column_Name)
 
0
Mohd Javed
 
 
Question
when will data in the data base is updated
Rank Answer Posted By  
 Question Submitted By :: Chaitanya
This Interview Question Asked @   IEG
I also faced this Question!!   © ALL Interview .com
Answer
when ever we use DML commands
 
0
Chaitanya
 
 
Answer
Please find the below link which is related to Practical 
PostgreSQL.

 

http://www.commandprompt.com/ppbook
 
0
Rajat
 
 
 
Question
what is the advantage of RAID
Rank Answer Posted By  
 Question Submitted By :: Bhavani
This Interview Question Asked @   Wipro
I also faced this Question!!   © ALL Interview .com
Answer
It maintains backups
 
0
Bhavani
 
 
Answer
It is a storage device, like floppy or hard disk 

RAID - Redundant Array of Independant Disks

RAID refers to a hard disk technology which can be used to
speed up data transfer and/or provide disk redundancy
through disk system fault tolerance.
RAID configurations are commonly found in data critical
applications.
 
0
Mohd Javed
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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