SQL

SQL Examples

SQL

SQL Projects

SQL Project



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

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

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);

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

% -

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