-
-
-
-
_______data type is used to store binary data such as graphics, sound, etcSQL uses ____________ clause to impose an order on the result of a query _________ function determines the number of rows or column values.The limit that determines the sphere of influence and control over a system is called_______________ is a graphic technique that can be used by analyst to represent the inputs and outputs.
-
Case function
if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1 Honda3 2 Suzukiwhat is the query to give follwing out putcustid cust name model model 11 A Toyota Honda2 ...
pravintule
- May 28th, 2010
Select c.custid,c.custname,m1.model,m2.model as model1 from customer c1,car m1,car m2where c.custid=distinct(m1.custid) and c.custid(+)=m2.custid
vinayak1234
- Mar 30th, 2010
SELECT c.custid, c.custname, m.model FROM custtable AS c JOIN carstable AS m ON c.custid = m.custidgroup BY c.custid, c.custname, m.model
-
Create View
Write an SQL statement to create views.
-
-
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- SELECT * FROM `table_name` WHERE rownum <> 1 ORDER BY rownum ASC LIMIT 1;
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.
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
SQL Interview Questions
Ans