how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables?
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d e f
g h
Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
Fname Lname City Pin
ramesh kumar salem 365241
Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters
Query to select passwords from a table having a column
"Password" Whose length is b/w 8 &15 and having 'A' as the
first character in the password irrespective of case.
i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K
and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
192
What view would you use to look at the size of a data file?
118
how to convert .db (extention) database file into .dmp
(extention ) for oracle database ?
what is diff between pre insert,on insert,post insert
triggers?
237
Define Check points and End Points?
22
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB
24
We are using Oracle apps with XML publisher.In that,we are
facing some problems while giving a Footer in RTF
Template.While giving a footer in RTF Template it is
Visible in all the pages,but after the PDF is getiing
generated,the Footer are Visible on alternate pages only
(like on first page ,third page) and so on.
Please provide the Solution for getting the Footer on all
the pages.
88
What is responsibility and how u attach
How to create user and how u attach with responsibility.
How to do Stored procedure testing? Who does this testing
(Developer or tester)?
72
Explain about query and reporting.
16
normally database take to refresh time 2 hours. but client
asked iwant to refresh with in 5 min that same database. do
you have any option in BO and Oracle? explain me briefly...kavi
What is the technical flow associated with P2P or Procure to
Pay cycle like the tables, APIs, concurrent programs
involved in this cycle. Only technical please.
hi,
how to link a text file and a .rpt file in my tables of sql
server and to retrieve those records for further use. reply
me as soon as possible.
45
Can anyone tell that the extra features are there in SQL
SERVER 2008 that are not available in previous versions .
61
How can you tell how much space is left on a given file
system and how much space each of the file system's
subdirectories take-up?
1
Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
Give two examples of referential integrity constraints.
215
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
