R4R
Right Place For Right Person TM
 
R4R Sql SQl FAQs Sql Interview Questions and Answers

 


Totel:174 Click: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

SQL Interview Questions And Answers

Page 1

 I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

Use primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts 

Deletion of duplicate records:
delete from emp a where a.rowid > (select min(b.rowid)
from emp b where a.rowid=b.rowid)

or

delete from table t1 where t1.rowid < (select max(t2.rowid) from table t2 where t2.<common column_name> = t1.<common column_name>)

 What is use of 'in' command?

in command use suppose u want to choose department then you use in command

ex=select ename,sal from emp
where deptno in(10,20);

 Class members
 What is the Sql Wild card?

SQL Wild Card is the bassically use for the searchign opration similarily LIKE function.SQL wildcards can substitute for one or more characters when searching for data in a database.
the following wildcards can be used:
>  % -	A substitute for zero or more characters 
>  _ - A substitute for exactly one character
>  [charlist] - Any single character in charlist
> [^charlist] or [!charlist] - Any single character not in charlist

% -

 Describe TO_DATE function?

The TO_DATE function using the values when we want to be show thw timestamp from a character string that has been interpreted using a character template.


Goto Page:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

SQL Objective Questions And Answers

SQL Objective Questions And Answers

SQL Interview Questions And Answers

SQL Subjective Questions And Answers


R4R,SQL Objective fresher and experienced, SQL Subjective fresher and experienced ,SQL Interview Questions And Answers,SQL fresher and experienced,SQL Interview fresher and experienced ,SQL Questions fresher and experienced,SQL Answers fresher and experienced

This section covers SQL interview questions and answers for fresher and experienced . In this section we covers SQL interview questions for experienced ,SQL interview questions for freshers .

This section covers SQL Objective interview questions and answers for fresher and experienced. In this section we covers SQL Objective interview questions for experienced ,SQL Objective interview questions for freshers

This section covers SQL Subjective interview questions and answers for fresher and experienced. In this section we covers SQL Subjective interview questions for experienced ,SQL Subjective interview questions for freshers

Tutorials,Examples,Questions and Answer

R4R
R4R
R4R
R4R
R4R
R4R
R4R
R4R