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

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

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

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

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

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

Asish

• Jan 7th, 2018

Rename: Renaming to a object.

Allows: Referring to a object to avoid the ambiguity on entity or attribute.

Pandurang

• Dec 15th, 2017

Rename is used to change the name of the table permanently.
Alias is the alternate name of the table

Answer Question  Select Best Answer

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Code
 

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 29th, 2012

Code
 

Answer Question  Select Best Answer

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

A view is stored procedure based on one or more tables, it’s a virtual table.

Suresh Babu Nallamothu

• Nov 8th, 2018

A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

A view is a mirror image of one or more table. View provides data access privilages.

Answer Question  Select Best Answer

'' Should be used before '%'.

Nazeera Jaffar

• Oct 6th, 2012

The below code selects the column with a substring % (e.g.) reg%istration

Code
 

Nazeera Jaffar

• Sep 30th, 2012

The below code will select the row having column as %

Code
 

Answer Question  Select Best Answer

peprah

 Profile Answers by peprah Questions by peprah

• Jan 20th, 2010

Sure why not?First of all you need to know and be sure of the table name and column you want to delete. There you are: DELETE FROM [TABLE_NAME]WHERE [ROW_NAME] = ['COLUMN_NAME']; EXA...

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 19th, 2010

First mark the column as unuse then drop the cloumn.

Answer Question  Select Best Answer

mfasiur

 Profile Answers by mfasiur Questions by mfasiur

• Jun 7th, 2012

Also, the undo blocks will store all the data until the transaction is either committed or rolled back.So, if someone issues DML statements(insert,update & delete)The before image of the transaction i...

Hany

• Jun 7th, 2012

With No Commit after delete , you will be able to see all record in session 2

Answer Question  Select Best Answer