GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

SQL Interview Questions


SQL Interview Questions

Questions: 170
Comments: 868
 SQL Tags
 Showing Questions 91-100 of 170 Questions
<< Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
 Sponsored Links

 
 SQL Interview Questions
Sorting Options :  

Latest Answer: An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query. ...
Read Answers (6) | Asked by : Rana

Latest Answer: LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1, children of the root are level 2, grandchildren are ...

What is the difference between single quote (') and double quote(") in relates to using in SQL. When do you use 'xxx' and "xxx"? what is the difference both of them?
Read Answers (3) | Asked by : michelle

How to delete set of records at a time where all the records having same values , except the Rowid differs?
Read Answers (3) | Asked by : myquery

Latest Answer: the ROWNUM is a number(like serial no) which is dynamically changes.but the ROWID does not change.Because it is having the unique address,which is generated by the oracle ...
Read Answers (6) | Asked by : kamaldass

SESSION 1 SESSION 2 ---------------- -------------------- DELETE FROM EMP; SELECT * FROM EMP;What will be the result?
Read Answers (13) | Asked by : chiranjeevi reddy

Latest Answer: select d.amount from (select t.tadichallan_amt amount,rank() over (order by t.tadichallan_amt desc) as Rank1 from tae_challan_det t where t.tadichallan_amt is not null )dwhere Rank1 between '&n' and '&d' ...
Read Answers (9) | Asked by : Dev

Latest Answer: The CASE statement supported by PL/SQL is very similar to the CASE expression. The main difference is that the statement is finished with an END CASE statement rather than just END. The PL/SQL statements are essentially an alternative to lists of IF .. ...
Read Answers (2) | Asked by : samba

Latest Answer: Hi,what nachs has written is correct.Show error is use to find the compilation error not run time error.For runtime error of procedure we need to take help of exception Handling and that error may be user defined or system defined. but we can handle it ...
Read Answers (2) | Asked by : mahesh shoriya

Latest Answer: We can change the column name. ...
Read Answers (20) | Asked by : sheela

View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
Free White Papers & Software


Vulnerability Management
for Dummies eBook

 


 

Request Your Copy
 



Free: 60-Day Trial
Microsoft Office Project

 


 

Request Now
 



The 7 Things that
IT Security Professionals
MUST KNOW!

 


 

Request Your Free eBook

 
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape