-
-
How to find the 9th row in emp table.
Sivaprasad
- Apr 1st, 2015
Select ename,Sal from emp
where rownum < 10 minus Select ename,Sal from emp
where rownum < 9
-
Find the Latest Salary of each Employee in Employer table
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 -
What command is used to create a table by copying the structure of another table?
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
- 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
- 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
-
Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus
krishnaveni_g
- Jul 17th, 2008
Where clause is the correct answer. Order of execution iswheregroup byhaving
-
Which of the following statements is not true about views?A. You can create an index on viewsB. Views do not have permanent dataC. Views can be based on one or more tablesD. Views can be dropped without dropping tables
-
Can you create a table by using pl/sql?if u so justify your answer;
-
Difference between Cluster and Non-cluster index?
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
- 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...
-
How to retrieve the 2nd record from a table ?
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- span style="color: #ff0000;">`table_name`
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)What is reference cursor?
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.
How to change the column name by using ALTER?
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
- Aug 26th, 2015
In T-SQL its not possible to rename the column name therefore use sp_rename
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...
Difference between joins and subquery?
Why do we use joins, instead subquery has same operation?
Display the employee details who joined before 5 days.
Write a query to display the employee details who joined before 5 days.
Muneeb
- Jan 11th, 2016
CodeQuery to Get Highest Marks Output
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
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language (DDL)
What is table space?
I want to know the answer
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
- 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.
How to display duplicate rows in a table?
Select * from emp where deptno=any(select deptno from emp having count(deptno)>1 group by deptno);
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
- Mar 26th, 2009
Select * from acctcycle where acct_nbr in (select acct_nbr from acctcycle group by acct_nbr having count(acct_nbr)>1);
What is Dual table?
What is dual table which is used as a table in sql...
Read Best Answer
Editorial / Best Answer
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
- 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
Read Best Answer
Ans