SQL Interview Questions

Questions: 170

Comments: 868

SQL Tags

—

DBMS

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 :

What is an inline view?

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

Answer Question Subscribe

Explain psudo column Label with an example

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 ...

Read Answers (5) | Asked by : prafull.vn

Answer Question Subscribe

What is the difference between single quote (') and double quote(") in relates to using in

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

Answer Question Subscribe

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

Answer Question Subscribe

What is the difference between ROWNUM and ROWID

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

Answer Question Subscribe

SESSION 1 SESSION 2 ----------------

SESSION 1 SESSION 2 ---------------- -------------------- DELETE FROM EMP; SELECT * FROM EMP;What will be the result?

Read Answers (13) | Asked by : chiranjeevi reddy

Answer Question Subscribe

How to get first 5 Records then next 5 records till end of row count in SQL -Oracle

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

Answer Question Subscribe

Difference between case expresssion and case statement

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

Answer Question Subscribe

How to find errors of PROCEDURE at run time( not complie time) ?

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

Answer Question Subscribe

Is there any way we can change the column name in a table

Latest Answer: We can change the column name. ...

Read Answers (20) | Asked by : sheela

Answer Question Subscribe

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

Go Top

#	User Name	Count
1	rampratap409	59
2	patilpravin_1981	26
3	g_sidhu	23
4	kowmudiswarna	13
5	ddkdhar	13
6	krishnaindia2007	12
7	globalanil18	10
8	nileshsingh	8
9	sbagai2001	8
10	dmadhusudhanarao	7

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX