SQL Interview Questions

Questions: 170

Comments: 868

SQL Tags

—

DBMS

Showing Questions 71-80 of 170 Questions

<< Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>

Sponsored Links

SQL Interview Questions

Sorting Options :

Create a query that displays the employees' last names and commision amounts.If an employee does

Create a query that displays the employees' last names and commision amounts.If an employee does not earn commmission, put "No Commission." Label the column COMM.

Read Answers (9) | Asked by : zecar

Answer Question Subscribe

What is Complex View?Where we can use?

Latest Answer: we go for complex views when we want to display from two or more tables, using group cluase, or grouping, aggregate functions ...

Read Answers (3) | Asked by : vasudeva123

Answer Question Subscribe

What is difference between Varchar2 and Nvarchar2?

Latest Answer: SQL Server provides both datatypes to store character information. For the most part the two datatypes are identical in how you would work with them within SQL Server or from an application. The difference is that nvarchar is used to store unicode data, ...

Read Answers (2) | Asked by : Ram Manohar Kumar

Answer Question Subscribe

What is the internal structure of database and how sql is related with it?

Latest Answer: Very Simple question! But should be explained a lot.Databse data is stored in data_file's of the databse. For every table's data some space from the data_files would be allocated. This space is known as data segment. Say, you have a table named EMP. There could ...

Read Answers (1) | Asked by : amit mandal

Answer Question Subscribe

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query

Write query for the following questions1. sql query for selecting alternate rows in a table2. sql query for deleting alternate rows in a table

Read Answers (7) | Asked by : lokesh

Answer Question Subscribe

1) how many number of tables we can join in join concepts?is there any limitation?i think its not...2)

1) how many number of tables we can join in join concepts?is there any limitation?i think its not...2) since joins and subqueries are used for same purpose , why we have two things.is there any need

Read Answers (5) | Asked by : oranachs

Answer Question Subscribe

On index why u need indexing ? where that is stroed and what u mean by schema object?for what purpose

On index why u need indexing ? where that is stroed and what u mean by schema object?for what purpose we are using view

Read Answers (2) | Asked by : basukolur014

Answer Question Subscribe

What is the difference between oracle,sql and sql server

Latest Answer: hii am shailendraits my opinionoracle is based on RDBMS. its follow the 10-11 rules in Dr. E.F.Codd but SQL Server is based on RDBMS. its follow the only 7-9 rules in Dr. E.F.Codd. ...

Read Answers (4) | Asked by : prasanna

Answer Question Subscribe

How to retrieving the data from 11th column to n th column in a table.

Latest Answer: declare @a varchar(1000),@tblname varchar(100),@b nvarchar(1000)declare @startcol int,@i int, @endcol intselect @startcol = 11, @endcol =13, @a='', @tblname = ''select @a = sc.name + ',' + @a from ...

Read Answers (11) | Asked by : Hokrani

Answer Question Subscribe

Difference between decode and case.in which case we are using case and in which case we are using decode?with

Difference between decode and case.in which case we are using case and in which case we are using decode?with an example.

Read Answers (8) | Asked by : Rashmi Das

Answer Question Subscribe

View page << Previous 4 5 6 7 [8] 9 10 11 12 13 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