seemu123

 Profile Answers by seemu123 Questions by seemu123

• Jul 1st, 2008

You can use like thisSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..Tablenameex:Select top 10...

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

One which i faced but till yet couldnt solved was like i am having 50 db's, each db's having 100 customersi wanted top 10 customer for each 50 db's according to their salary in oraclethough it sounds easy but  according to my knowledge its not so

Answer Question  Select Best Answer

how to delete identical row from a table?

if we have 4 row and two of them having same data then how we delete identical row using delete query

Ashok Aaruu

 Profile Answers by Ashok Aaruu Questions by Ashok Aaruu

• Oct 22nd, 2011

Its not clear...... it will be execute correctly?

Siraj

• Oct 15th, 2011

Delete from table_name where rowid not in (SELECT max(rowid) FROM table_name group by (column_name))

Answer Question  Select Best Answer

If i have two table T1 having data of column C1,C2,C3 and C4 and T2 having data of column C5,C6,C7 and C8,How to copy Data of T2 to T1 or T1 to T2

Aakash

• Mar 22nd, 2015

INSERT INTO T1
(
SELECT
C5,
C6,
C7,
C8
FROM T2)

smamish

 Profile Answers by smamish Questions by smamish

• Mar 22nd, 2015

Code
 

Answer Question  Select Best Answer

Vipin

• Jul 7th, 2015

It is always a good practice to create a Clustered Index on the Primary key and make sure that the Primary key is sequential. A table can have only one clustered index where as a table can have unlimi...

saira banu

• Jun 10th, 2015

Table

Answer Question  Select Best Answer

How to delete reverse duplicate in oracle.
e.g i/p
col1 col2
hyd blr
mum del
del blr
blr hyd
blr del

i want in o/p
col1 col2
hyd blr
mum del
del blr

Priyanka Jaiiswal

• Aug 17th, 2017

SELECT a.col1 ,a.col2 from t1 a
where a.col1 < = a.col2

manish

• Feb 7th, 2017

SELECT a.mem_name,a.loc_name
FROM TAB4 a
WHERE a.loc_name = a.mem_name;

Answer Question  Select Best Answer

EID ENAME SAL SALMONTH
101 xyz 100 Jan 2015
101 xyz 200 Feb 2015
102 Abc 300 Feb 2015

I want output like this
Eid Ename hike
101 xyz 100
102 Abc 0

Akash

• Aug 15th, 2017

Can you elaborate what you are solving its not about duplicates

dan

• Jul 31st, 2015

The question is poorly stated, perhaps partially stated as well. But it is good that basic sample data is given. Does the table have data only for Jan 2015 and Feb 2015.? What if the salary changes we...

Answer Question  Select Best Answer

My Question is :

I have one table , from this table I have 1000 records. Particularly I need retrieve the 5th record only.
no need retrieve 1 to 4th only 5th record only I need retrieve by using SQL Query?

dan

• Jul 31st, 2015

Such requirement is fundamentally incorrect. Yes, such a need might arise when data from a non-RDBMS source has been imported into a RDBMS. If some one forethought should be given to identifying the ...

pravalika

• Jul 2nd, 2015

Code
 

Answer Question  Select Best Answer

I have 2 tables. Table A and Table B. I want to display all the rows from both the tables. can anyone help me on this??

isha

• Sep 5th, 2015

UNION or UNION ALL can be used if all column names are same in both the tables... else use join condition to retrieve data from both the tables if the tables have at least one common column

YK

• Sep 4th, 2015

Use Union ALL

Answer Question  Select Best Answer

How to write a query to list the items in ascending order of Name and within Name, in descending order of Salary

vaibhav

• Jan 11th, 2016

Code
 

cocoole

 Profile Answers by cocoole Questions by cocoole

• Jan 7th, 2016

Order by name, sal desc

Answer Question  Select Best Answer

There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6

display the result as :

1 2 3
4 5 6

Santhosh Kumar Gujja

• Nov 27th, 2017

Sel max(case when rn=1 then c1 end),max(case when rn=2 then c1 end),max(CASE WHEN RN=3 THEN c1 end)
union all
sel max(case when rn=1 then c2 end),max(case when rn=2 then c2 end),max(CASE WHEN RN=3 THEN c2 end)2
(
SEL c1,c2,row_number() over(order by C1) as rn
)O

vikas bose

• Nov 3rd, 2017

In MySQL, we have one function GROUP_CONCAT(field_value, separator). It will give single row.
SELECT GROUP_CONCATE(field_Value, ,) FROM table_name where 1 group by field_name.

Answer Question  Select Best Answer

I need to list the employees hired after any random date, lets say 10th December 2010 in ascending order and minus their salary by 100% how would I do this?

Pendo

• Jul 17th, 2021

SELECT * FROM Employees WHERE CAST(DATE AS DATE)>20101210

Pratiksha Chacan

• Aug 24th, 2019

Select * from employee e where to_char(hiredate, YYYY)=2019;

Answer Question  Select Best Answer

Answer :DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.Explanation : The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.

anuraganu100

 Profile Answers by anuraganu100 Questions by anuraganu100

• Jul 9th, 2010

DESC is used with ORDER BY clause i.e.SELECT * FROM usermaster ORDER BY userid DESC

rekhask

 Profile Answers by rekhask Questions by rekhask

• Sep 11th, 2007

DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym DESC function DESC package

Answer Question  Select Best Answer

SELECT TRUNC(1234.5678,-2) FROM DUAL;1200

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

if the -ive parameter is passed under TRUNC function truncation will be used to below decimal place i.e-1 means Trunc to 10th (1234 becomes 1230)-2 means trunc to 100th (1234 becomes 1200)-3 means tru...

thumati_nagaraju@yahoo.co.in

• Nov 17th, 2006

This is -ve no given so it remove the digits before decimal point ... and replace it by zero if want to check it just try with -1 or -2 or -3 ok seeu byeee

Answer Question  Select Best Answer

LIKE operator

pujavipin

 Profile Answers by pujavipin Questions by pujavipin

• Jun 4th, 2009

LIKE operator can be used in a WHERE clause to search for a particular pattern from columns in a table.Syntax: SELECT column_name(s) from table_name WHERE column_name LIKE pattern.

mehraban_b

 Profile Answers by mehraban_b Questions by mehraban_b

• Mar 15th, 2007

%

Answer Question  Select Best Answer

TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.

psingla

 Profile Answers by psingla Questions by psingla

• Mar 16th, 2010

SQL Sever:Truncate:Delete all the records from the table.Do not keep the deleted record in the log file.Reset the identity column to 1.Use fewer locks with table level locking.Tollback is not possible...

saravanan p

• Dec 5th, 2006

Hi,1. For truncate command, trigger will not get fired, but for Delete Command, Trigger will get fired.2. Truncate Is the DDL command whereas Delete is the DML command3.Once the truncate command ...

Answer Question  Select Best Answer

malapati

 Profile Answers by malapati Questions by malapati

• Oct 9th, 2008

To copy a table along with records create table  as select *from ;if we want to copy only structure   create  table < new tablename> select *from  where ;

ravi

• Jun 12th, 2006

Yes , we can copy the table structure. create table as select * from where 1=2;

Answer Question  Select Best Answer

Rakesh

• Feb 7th, 2012

Normalization--To Reduce or to remove the redundancy in table we used Normalization and the normalization we can achieve by breaking of tables by this table is in Normalized.

prabu

• Jul 13th, 2011

0NF "sql CUSTOMER ORDER (CustName, OrderNo, ProdNo, ProdDesc, Qty, CustAddress, DateOrdered) 1NF - remove multivalued attributes "sql CUSTO...

Answer Question  Select Best Answer

farhad1

 Profile Answers by farhad1 Questions by farhad1

• Sep 24th, 2008

Select * from global_name;

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 5th, 2008

SQL> select name from v$database;NAME---------ORCL

Answer Question  Select Best Answer

rangunagaraj

 Profile Answers by rangunagaraj Questions by rangunagaraj

• Jul 6th, 2007

NORMALIZATION is a body of rules addressing analysis and conversion of data structures into relations that exhibit more desirable properties of internal consistency,minimal redundancy and maximum stab...

Ranjeev

• Apr 26th, 2006

Normalisation can be defined as a process to minimize, infact eliminate redundancy of data within the database. It first requires that redundancy is detected through the proper use of FD's( Functional...

Answer Question  Select Best Answer

rajneeshbajwa

 Profile Answers by rajneeshbajwa Questions by rajneeshbajwa

• Dec 22nd, 2006

Hi Frienz...According to me WHERE and HAVING both are equally important..WHERE is used for condition on a single row and it comes before group by clause...whereas HAVING is used with GROUP BY alwayz.....

mamathi

• Oct 27th, 2006

we can use where clause for single function only. haveing clause we can use more then one function in a clause.exselect * from table namewhere salary > 10000;ex havingselect *from table namehaving sa...

Answer Question  Select Best Answer