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: 168
Comments: 839
 SQL Tags
 Showing Questions 1-10 of 168 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 SQL Interview Questions
Sorting Options :  

Latest Answer: There can be as many as all the number of columns of the table which can be used in the GROUP BY clause. Oracle Server handle of this itself. ...
Read Answers (5) | Asked by : radha11

There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10  
Latest Answer: SQL> update student set maxmarks=greatest(m1,m2);I took 'student' as the table name. ...

Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed 
Latest Answer:  create table emp2 as(select Substr(ename,1,instr(ename,',')-1) as last,   substr(ename,instr(ename,',')+1,length(ename)) as first  from emp1) ...
Read Answers (3) | Asked by : ssq1999

what is difference between nested query,sub query and nested query? explain clearly with an example? 
View Question | Asked by : pvsp.indian

How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let 
Latest Answer: We can not select a particular column values without knowing it's name. However, we can select all the columns from a table using the following statement.SELECT * FROM table_name; ...

Latest Answer: The answer depends on release. Before 10g it was possible, starting with 10g - no. ...
Read Answers (3) | Asked by : ashish88

WE using Last_value()analytical function but the result do not match according to me? 
View Question | Asked by : ashish88

How and in what way REPLACE is different from TRANSLATE? 
Latest Answer: REPLACE: It is used to replaces the value,without giving the alternative letter or word.Ex:1. select replace(ename,'S') from emp;     2.select replace(ename,'S','A') from emp;TRANSLATE: Here you must apply ...

What are Column Level Constraint and Table Level Constraint? How do they differ from one another? 
Latest Answer: Table level constraint:Ex: create table emp(empno integer,ename varchar(20),deptno integer,primary key(empno))column level constraint:create table emp(empno integer primary key,ename varchar(20),deptno integer)In table level need create constraint ...

Latest Answer: Use below queryselect unique * from table_name; ...

View page [1] 2 3 4 5 6 7 8 9 10 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

 




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