kitty

• Sep 8th, 2014

Can u plz explain me in detail about the answer you have provided with correlated sub query.

Thnks in advance !

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Dec 2nd, 2010

4th Highest Salary  1*  select a.last_name,a.salary from (select b.*,rownum rn from (select last_name,salary from employees order by salary desc)b)a where rn = &nSQL> /Enter value for...

Answer Question  Select Best Answer

ngoudjou albert

• May 22nd, 2012

We use the selfjoin on the table employees to retrieve the job before thier managers

Code
 

janardhan g

• Aug 7th, 2011

Select x.ename from emp x,emp y where x.mgr=y.empno and x.hiredate

Answer Question  Select Best Answer

By using DISTINCT

kethinenisarath

 Profile Answers by kethinenisarath Questions by kethinenisarath

• Apr 9th, 2011

Hi! I think its best option to avoid duplicating records in a queryselect * from empwhere sal in ( select sal from emp                  &nbs...

kethinenisarath

 Profile Answers by kethinenisarath Questions by kethinenisarath

• Mar 29th, 2011

HIselect * from empwhere sal in (select  sal  from emp                      group by ...

Answer Question  Select Best Answer

punkaj

• May 24th, 2017

Using LISTAGG(colname) within group(order by col)

Bikesh Srivastava

• Aug 5th, 2016

use this code to seprate row value in single coulmn"mysql // Create coloumn with seprated column value.from row value SELECT DISTINCT p.[Account ID],p.[Contact ID],p.[Account Nam...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Srinivas4u  

 Profile Answers by Srinivas4u Questions by Srinivas4u

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

---

I am sure that a group by clause can have all columns which are there in that table,not sure if you are looking for anotehr answer

akshya dash

• Jul 25th, 2011

there can be n no of columns in a group by clause other than group functions for ex select ename, deptno max(sal) from emp group by ename,deptno; here max(sal) is a group function and ename and ...

sasanka

• Jul 21st, 2011

In GroupBy clause contains the no of columns in the select Statement to retrieve the data.

Improve Answer

How to rename a column in a SQL table?

Read Best Answer

Editorial / Best Answer

sravee123  

 Profile Answers by sravee123 Questions by sravee123

• Member Since May-2008 | Jun 10th, 2008

---

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Code
 

karthickrfwin

 Profile Answers by karthickrfwin Questions by karthickrfwin

• Sep 22nd, 2011

Use this Script for nename particular ColumnName in SqlTable

sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column'

Improve Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select * from hello h where 1=(select count(discnt amt) from hello where h.amt

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Dec 25th, 2010

Say for example below are data exist on EMP tableEMPNO  EMPNAME                DEPTNO      ...

Answer Question  Select Best Answer

select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') >'col_name')group by level;Example:Given a table called emp with the following columns:-- id number-- name varchar2(20)-- sal number---- For the second highest salary:-- select level, max(sal) from emp-- where level=2-- connect by prior sal > sal-- group by level

nklpunitha

 Profile Answers by nklpunitha Questions by nklpunitha

• Feb 20th, 2010

Try the below query, it will give the correct output Select * from emp where salary = (select min(salary) from (select distinct salary from emp order by salary desc) where rownum < n)

Avashisth

 Profile Answers by Avashisth Questions by Avashisth

• Feb 20th, 2010

-- To get nth Highestselect distinct salary from (select salary,dense_rank() over(order by salary desc) as sal from Table )where sal = &n--To get nth Lowestselect distinct salaryfrom (select salary,dense_rank() over(order by salary) as sal from Table ) where sal = &n

Answer Question  Select Best Answer

BRAHMAM

• Dec 6th, 2017

SELECT * FROM EMP E1 WHEERE N-I=(SELECT COUNT(DISTINCT SAL) FROM EMP E2 WHERE E2.SAL>E1.SAL

Ranaj KumarParida

• Jul 28th, 2017

SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL &LEVEL
CONNECT BY PRIOR SAL > SAL
GROUP BY LEVEL
ORDER BY LEVEL;

Answer Question  Select Best Answer

Dheeraj Singh

• Sep 16th, 2018

You can try this one.I think this query can work..

Select * from tbl_regex Where REGEXP_LIKE(ENAME,^0123456789);

Note:- tbl_regex is table name and ENAME is column name that contain numeric and string type data.

Asish

• Jan 7th, 2018

Here the where clause will be either

Lower(fn) = upper(fn)

Or

Regexp_like(fn, ^[0-9]*$)

Answer Question  Select Best Answer

farhan

• Apr 20th, 2012

Code
 

uma

• Mar 6th, 2012

Select * from emp a
where salary >(select avg(salary) from emp b where a.dept_no = b.dept_no);

Answer Question  Select Best Answer

Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.

Read Best Answer

Editorial / Best Answer

ajaysinghnegi  

 Profile Answers by ajaysinghnegi Questions by ajaysinghnegi

• Member Since Mar-2009 | Mar 27th, 2009

---

1) HAVING clause can only be used to filter out the aggegate functions whereas WHERE clause cannot filter out the aggegate functions.
2) HAVING clause can be used with GROUP BY function where as WHERE clause cannot be used with group by function.

gubba123

 Profile Answers by gubba123 Questions by gubba123

• Aug 8th, 2010

Example: Write a query to display the Managers who are working for more than one Departments:Select  emp_id, count(distinct dept_id)     From emp     Where...

Tartauris

 Profile Answers by Tartauris Questions by Tartauris

• Feb 16th, 2010

Having is used for agregate results while where is used for unagregated results.

Improve Answer

Bibhuprasad Behera

• Dec 4th, 2015

Can you please send me the example of the trigger?

Nivetha Thinakaran

 Profile Answers by Nivetha Thinakaran Questions by Nivetha Thinakaran

• May 5th, 2015

In an autonomous transactions, we can have commit inside trigger.

Answer Question  Select Best Answer

Mohammad salman

• Sep 29th, 2018

Its not working,,,,
error is that


Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword As.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table emp as select * from student where 1=2;

Answer Question  Select Best Answer

Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed to write a SQL query to convert the data from Emp1 to Emp2 in this way.Can any body help me.Thanks

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Nov 16th, 2010

SQL> select * from name;NAME--------------------Girija,Sankar  1* create table split_name as(select substr(name,1,(instr(name,',') -1)) "First",substr(name,(instSQL> /Tabl...

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 22nd, 2010

SELECT substr(ename instr(ename, ',')+2) First ,substr(ename, 1, instr(ename, ',')-1) Last FROM emp1;has to be +2 because of the space after comma

Answer Question  Select Best Answer

Maria

• May 16th, 2017

With GROUP BY statement.

Palak

• Apr 20th, 2017

By using Unique Command

Answer Question  Select Best Answer

How to display middle record in a given table?

Bibhudatta Panda

• Jun 18th, 2019

Suppose I want middle record 5-9 records

Code
 

shreyas varchasvi

• Oct 15th, 2018

In rownum we cant use >= operator, only < ,< = operator will work.

Answer Question  Select Best Answer

Bharathiarun

• Aug 20th, 2015

Even if the Id is varchar, the rows are ordered by rownum.

Anand Prakash Joshi

• Aug 10th, 2015

Code
 

Answer Question  Select Best Answer

Hi,

Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions.

If I do a select * from emp and select * from emp1 now, which one should execute faster and why?

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

TRUNCATE TRUNCATE does not return number of deleted rows. TRUNCATE TABLE always locks the table and page but not each row. DELETE When we have to use DELETE Command then the data deleted can be ...

Mohammad Mansoor

• Feb 24th, 2016

Truncate and Drop commands Rollback is not possible for Table, whereas Delete Command we rollback the Data

Answer Question  Select Best Answer

How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer

suganthi

• Jul 3rd, 2015

How to display data from table values without using select command?

kranthiswaroop

 Profile Answers by kranthiswaroop Questions by kranthiswaroop

• May 6th, 2014

Hi Sanjoy, Its a simple logic that, one should have complete idea about the Table , Table fields and data types used.. before applying any DML DCL DDL Commands, a programmer shoud know this. A progra...

Answer Question  Select Best Answer