ratnam

• Aug 3rd, 2012

How write a SQL statement to query the result set and display row as columns and columns as row?

Vasanth Kumar

• Oct 6th, 2006

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

Answer Question  Select Best Answer

amy

• Mar 20th, 2007

Select e1.name, e2.name, e3.namefrom employee e1 left join employee e2 on e1.manager_id = e2.employee_idleft join employee e3 on e2.manager_id = e3.employee_id

biswa

• Jul 11th, 2006

 SELECT worker.ENAME || ' works for '  2  || manager.ENAME  3  FROM emp worker, emp manager  4  WHERE worker.mgr = manager.empno ;where emp is the tableEMPNO ENAME&n...

Answer Question  Select Best Answer

jimmy514in

 Profile Answers by jimmy514in Questions by jimmy514in

• Jul 2nd, 2010

Why cannot we use select * from table_name where rownum=70??

krishna

• Sep 26th, 2006

select * from emp where rownum<71minusselect * from emp where rownum<70;

Answer Question  Select Best Answer

How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime column senttime column?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Nov 28th, 2010

  select  to_date(insertime,dd/mm/yy)-to_date(sentime,dd/mm/yy) as date_differnce   from table_name;

rkh_301

 Profile Answers by rkh_301 Questions by rkh_301

• Aug 12th, 2010

If the fields are defined as TIMESTAMP type, you could do something like below.  In this query, the startdttm and enddttm fields are defined as TIMESTAMP type:select phasename, stepname, enddttm-startdttm as Elapsed from psupgstatuswhere runname = 'dlm_v4d_b018';

Answer Question  Select Best Answer

How could i delete the distinct name from the table. the rest record would be available as it is in the table?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Nov 28th, 2010

 delete from table_name where column_name in (select distinct(column_name) from table_name);

preethi

• Jan 9th, 2007

To remove distinct rows from a table use thisdelete from table_name where column_name in (select distinct(column_name) from table_name);If u want unique values select distinct (column_name) from table_name ;

Answer Question  Select Best Answer

Lakshaman

• Jan 24th, 2007

An exampleWe accept user and password and validate likeselect 1 from users where username = 'username' and password = 'pwd';What if username string is passed like [x' or 1=1; --]select 1 from users where username = 'x' or 1=1; --' and password = 'pwd';

sabithagopi

 Profile Answers by sabithagopi Questions by sabithagopi

• Jan 23rd, 2007

SQL Injection happens when a developer accepts user input that is directly placed into a SQL Statementand doesn't properly filter out dangerous characters. This can allow an attacker to not only stealdata from your database, but also modify and delete it.

Answer Question  Select Best Answer

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

By default the "select" statement retreives the data in "unsort" form. If we want to sort the data we need to use "ORDER BY" clause. eg: select * from < table name > order by < column name >;?if we specify "desc" after column name it sort out in desending order otherwise default is asending order

Lavu

• May 6th, 2007

If you are selecting the data from the table it will not sort the data. If you are using group by clause then it will sort the result in the ascending order other wise not.

Answer Question  Select Best Answer

Ayush.sh

 Profile Answers by Ayush.sh Questions by Ayush.sh

• Mar 31st, 2009

To add in above mentioned constraints for using functions in DML statements:- Called function should not end a transaction

raji_4u

 Profile Answers by raji_4u Questions by raji_4u

• Sep 19th, 2008

Who says we cannot?We can call stored functions from DML statements but follow some rules
The rules:----------1. Function should use only IN parameter mode. Don't use OUT or IN OUT mode.2. Functions used in Select statements should not update database tables, where as others can update database.

Answer Question  Select Best Answer

What is the process that we use to load the data faster when there are millions of files?

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

Use SSIS. But with in SSIS use SQL Server Destination adaptor instead of OLEDB Destination. But when we use SQL Server Destination adapter we can only run either on server or from SQL agent job.

Ayush.sh

 Profile Answers by Ayush.sh Questions by Ayush.sh

• Mar 31st, 2009

For loading data files or flat files into DB, Unix utility SQL Loader is best suited. can load milions of records in just few secs. Easy to use and compatible with Unix, shell, PERL. Uses control file(.ctl) and parameter file(.par)to direct instructions.

Answer Question  Select Best Answer

sunil_ronanki

 Profile Answers by sunil_ronanki Questions by sunil_ronanki

• Oct 16th, 2008

Alter table drop constraint check [name of the constraint]

malapati

 Profile Answers by malapati Questions by malapati

• Oct 8th, 2008

Alter  table  drop  constraint  check;

Answer Question  Select Best Answer

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