abid

• Jul 30th, 2015

ALTER USER ABC IDENTIFIED BY XYZ; if user does not exist it will create user

laxmi

• Apr 28th, 2015

Yes, create user identify by
Its created by DBA

Answer Question  Select Best Answer

Sivaprasad

• Apr 1st, 2015

Select ename,Sal from emp
where rownum < 10 minus Select ename,Sal from emp
where rownum < 9

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Sep 27th, 2011

SELECT * FROM store_chr_val WHERE ROWNUM

Answer Question  Select Best Answer

How to find the latest salary of each employee in the Employer table?
emp.id sal year month
1001 5000 2015 3
1001 3000 2014 4
1002 4000 2013 3
1003 2000 2013 2

SANTHOSH KUMAR GUJJA

• Nov 26th, 2017

SEL EMP.ID,SAL FROM
EMPLOYER QUALIFY ROW_NUMBER() OVER(PARTITION BY EMP.ID ORDER BY YEAR,MONTH DESC)=1

anagogia

• Sep 29th, 2016

The query has to be a nested query because one employee could have the max (year||month) = 201503 where he had max salary and other could have max(year||month) = 201603 where he had the max salary ......

Answer Question  Select Best Answer

Answer :CREATE TABLE .. AS SELECT commandExplanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.

Bhuvaneswari.V

 Profile Answers by Bhuvaneswari.V Questions by Bhuvaneswari.V

• Aug 22nd, 2009

SELECT * INTO NewTable FROM ExistingTable WHERE 1 = 2 will copy the structure of the existing table without any data. If we need the NewTable with data we can filler the records in WHERE clause.

padma.rkp

 Profile Answers by padma.rkp Questions by padma.rkp

• Apr 28th, 2007

IN ORACLE:create table new_table_name asselect col1,col2 from old_table_name where 1=2IN SQL SERVERSelect * into new_table_name from old_table_name where 1 = 2

Answer Question  Select Best Answer

krishnaveni_g

 Profile Answers by krishnaveni_g Questions by krishnaveni_g

• Jul 17th, 2008

Where clause is the correct answer.  Order of execution iswheregroup byhaving

ravi.8311

 Profile Answers by ravi.8311 Questions by ravi.8311

• Jun 14th, 2008

Group by clause

Answer Question  Select Best Answer

henzchen

 Profile Answers by henzchen Questions by henzchen

• Mar 15th, 2010

A. You cannot create an index on a view.

mates04

 Profile Answers by mates04 Questions by mates04

• May 5th, 2008

All the answers mentioned above are true. This Question was posted long back at that point of time indexing was not possible in view. Now in SQL Server 2000 and Oracle latest versions its posible..

Answer Question  Select Best Answer

Veeranjaneyulu.G

 Profile Answers by Veeranjaneyulu.G Questions by Veeranjaneyulu.G

• Dec 1st, 2009

BEGINEXECUTE IMMEDIATE 'create table taki(a number)';END;

ravi.8311

 Profile Answers by ravi.8311 Questions by ravi.8311

• Jun 14th, 2008

Yes we can create table by using pl/sql progarm.ravi

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Sushant

• Oct 25th, 2006

---

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

Sameer

• Nov 1st, 2012

Now SQL SERVER 2008 onwards we can have 1 cluster index and 999 non cluster index on one table.

primarykey2000

 Profile Answers by primarykey2000 Questions by primarykey2000

• Apr 22nd, 2008

clustered index  - the index order matches the order of physically stored data.cluster index can be used on table that doent get changes frequentlyusing DML statement on cluster index column have...

Improve Answer

How to retrieve the 2nd record from a table which has say 1000 records in it. Please answer this without using the row-id? I tried to say a query "select * from table where rowcount=1" which worked well and also "select * from table where rowcount=3" which gave me the result but not when I did the same query "select * from table where rowcount=2" ? why?

rima

• Nov 24th, 2011

Code
SELECT * FROM `table_name` WHERE rownum <> 1 ORDER BY rownum  ASC LIMIT 1; 

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 27th, 2011

The best way to issue is

select top 1 * from cars where id_car in
(select top 2 id_car from cars order by id_car)
order by id_car DESC

and with that
obtain the second record (This way is for the PK)

Answer Question  Select Best Answer

arunkumarb6

 Profile Answers by arunkumarb6 Questions by arunkumarb6

• Jun 29th, 2011

It is a datatype

sandyl2

 Profile Answers by sandyl2 Questions by sandyl2

• Jun 22nd, 2011

A Normal Currsor is like a Constant but RefCursor is a Variable. RefCursor is a Dynamic Cursor. Main Advantage of RefCursor is same Cursor can be associated with different Select Statements.

Answer Question  Select Best Answer

I Tried by giving......................... ALTER table table name rename column tocolumn name was changed but it's not giving entire table with altered column name.It's giving only the altered column.

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

In T-SQL its not possible to rename the column name therefore use sp_rename

malapati

 Profile Answers by malapati Questions by malapati

• Oct 8th, 2008

to change name of one column   alter  table  <table name>rename column <old columnname> to <new columnname>;if we want to change more than one column  a...

Answer Question  Select Best Answer

Avanish Kumar

• May 26th, 2015

Rename table old_tablename to new_tablename

Neeru Nagi

• May 20th, 2015

In Sql_Server,

SP_RENAME old_table_name, new_table_name

Answer Question  Select Best Answer

Why do we use joins, instead subquery has same operation?

laxminarayana

• Oct 16th, 2015

JOINS are used to retriveing data from more then one table.
SUBQUERIES are used to condition depends upon one data retriving from another table at the time we use subqueries.

farhan

• Oct 15th, 2015

JOINs are used where you have a complex and large queries. SubQuery is used where you have a very simple scenario and your query is not too lengthy.

Answer Question  Select Best Answer

Write a query to display the employee details who joined before 5 days.

mukesh3208

 Profile Answers by mukesh3208 Questions by mukesh3208

• Jan 29th, 2016

Code
SELECT * FROM Employee_Salary WHERE DATEDIFF(dd,Hire_Date,getdate()) < 5

Muneeb

• Jan 11th, 2016

Code
SELECT * FROM emp WHERE DateDiff(dd,getdate(),hiredate) >5

Answer Question  Select Best Answer

Question: student marks stable "sp_report"
sid maths chem phy engl
1 33 45 54 48
2 55 32 50 37
3 10 20 30 40

The required o/p is (SQL QUERY TO GET THE BELOW O/P)
sid highest_marks
1 54
2 55
3 40

Paresh

• Jun 24th, 2016

Code
 
SELECT sid, Max(Marks) AS highest_marks
FROM sp_report
 Unpivot
(Marks FOR value IN( maths,chem,phy,engl)) AS Score
GROUP BY sid

Ade

• Jun 23rd, 2016

Code
SELECT sid,MAX(maths,chem,phy,engl) "highest_marks"
FROM marks
GROUP BY sid

Answer Question  Select Best Answer

Data Definition Language (DDL)

saran.k

 Profile Answers by saran.k Questions by saran.k

• Feb 9th, 2010

Data Definition Language (DDL)

rabbi08

 Profile Answers by rabbi08 Questions by rabbi08

• Jun 2nd, 2008

DDL: Data Definition Language is the subset which is used to manipulate Oracle database structures. i.e. Create, Alter, DropDML: Data Manipulation Language is the set used to manipulate the data withi...

Answer Question  Select Best Answer

B

irfan1patel1

 Profile Answers by irfan1patel1 Questions by irfan1patel1

• Nov 1st, 2015

B. 10

Mani Prakash Singh

• Oct 17th, 2015

10

Answer Question  Select Best Answer

I want to know the answer

amitarudra

 Profile Answers by amitarudra Questions by amitarudra

• Aug 7th, 2009

Every database is divided into logical storage unit? called Tablespace. This Tablespace is used to group related logical strutures together.

pujavipin

 Profile Answers by pujavipin Questions by pujavipin

• Jun 9th, 2009

Table space is the logical storage area on which different users would have quota to create and maintain their objects and data.

Answer Question  Select Best Answer

Select * from emp where deptno=any(select deptno from emp having count(deptno)>1 group by deptno);

ashwani7jul

 Profile Answers by ashwani7jul Questions by ashwani7jul

• Jan 20th, 2010

DELETE FROM test USING test, test AS vtable WHERE (test.ID > vtable.ID) AND (test.name=vtable.name)Deleted duplicate records  query  

mayank1710

 Profile Answers by mayank1710 Questions by mayank1710

• Mar 26th, 2009

Select * from acctcycle where acct_nbr in (select acct_nbr from acctcycle group by acct_nbr having count(acct_nbr)>1);

Answer Question  Select Best Answer

What is dual table which is used as a table in sql...

Read Best Answer

Editorial / Best Answer

svsraju81  

 Profile Answers by svsraju81 Questions by svsraju81

• Member Since Jul-2008 | Jul 24th, 2008

---

Dual table is a temporary table, it contains a single row and single column. If we return a data from dual table it gives a single row.

sudipta kumar dhal

• Sep 5th, 2011

Dual table is called a dummy table because it is not meant for storing any useful data.

d_pranjal

 Profile Answers by d_pranjal Questions by d_pranjal

• Sep 5th, 2010

Dual table is owned by SYS. Data dictionary come under SYS, dual is part of data dictionary. Dual table consist only one row and only one column containing value x

Improve Answer