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

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

Use below query to know index usage in SQL ServerSELECT   OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],          I.[NAME] AS [INDEX NAME],   ...

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 12th, 2008

sp_helpindex works for SQL server 2005

Answer Question  Select Best Answer

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

Since Foreign key accepts null values, then if we inset a record as NULL then how we can make Customer id as primary key in another table.

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

A column included in the definition of referential integrity which would refer to a referenced key.? Referenced key is a primary key which is combination of UNIQUE+NOT NULL".

Answer Question  Select Best Answer

Select emp_name, Dept_name from (Employee_table left outer join Dept_table on Employee_table.Dept_id = Dept_table.Dept_id)

Evghenii

• Jan 19th, 2007

Select A.ENAME as Employee, B.ENAME as Manager from EMP A, EMP B where A.MGR=B.EMPNO group by A.ENAME;

zero_cool

• Mar 6th, 2006

Select ename, dnumber from employee left outer join department; I think that would be enough without necessarily saying "where employee.dnumber = department.dnumber since we are using "LEFT OUTER JOIN" statement--zero cool--

Answer Question  Select Best Answer

I have following table as books101 BOOK_NO BOOK_NAME AUTHOR_NAME COST CATEGORY1234 C Dennis 450 System1235 Oracle Loni 550 Database1236 Sql Loni 250 Database1237 Pl/Sql Scott 750 Database Now I want to List all the authors and book name that has more then 1 book written by them.pls help

Pravalika

• Jul 2nd, 2015

Code
 

Avinash

• Jun 24th, 2012

Select AUTHOR_NAME,BOOK_NAME from books101
where AUTHOR_NAME in
(select author_name from books101 group by author_name having count(*)>1);

Answer Question  Select Best Answer

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

CREATE PROCEDURE xyxWITH ENCRYPTION ASBEGIN...ENDBut you need to know database master key to decrypt this stored procedure to view code.

vavasudevan

 Profile Answers by vavasudevan Questions by vavasudevan

• Feb 13th, 2007

Hi,Even we can use "Encryption" Keyword in MSSQL with Proc... this'll hide text of the Proc from User.Eg.,Create Proc Proc1As Select 1 While Taking sp_HelpText for Proc1, it'll return text written ins...

Answer Question  Select Best Answer

Sunil Langeh

 Profile Answers by Sunil Langeh Questions by Sunil Langeh

• Mar 22nd, 2007

Yes, to do so ,firstly we have to delete records from the child category/table

PRASHANTKULAT

 Profile Answers by PRASHANTKULAT Questions by PRASHANTKULAT

• Mar 7th, 2007

We can delete record from Parent table. But to do so We have to delete records from child tableTo do so You can write Trigger (Before delete trigger) on the Parent Table which will delete all the child records.

Answer Question  Select Best Answer