GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Database  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 137 of 139    Print  
Single Row Function
Display details of employees having same char at the star and end postition of their name

like

abishika

this name have last character and first character is same


  
Total Answers and Comments: 13 Last Update: November 03, 2009     Asked by: sunil_bisht 
  
 Sponsored Links

 
 Best Rated Answer
—
Submitted by: shini Gupta
 
select  * from tbl_users where username like 'char%' and username like '%char'

Above answer was rated as good by the following members:
TECHFAZ, Mamta11, HussainExpect, luzaolai, mkamalji, harish.kasu
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
August 06, 2008 06:55:27   #1  
mv_sivavardhan Member Since: August 2008   Contribution: 6    
RE: Single Row Function

select * from tbl_users with(nolock)

where right(username 1) left(username 1)


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
August 07, 2008 03:03:19   #2  
msrao226 Member Since: August 2008   Contribution: 1    
RE: Single Row Function

select * from tbl_users with(nolock)

where substr(username 1 1) substr(username -1 1)


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 1Overall Rating: -N/A-    
August 21, 2008 14:28:48   #3  
shini Gupta Member Since: August 2008   Contribution: 1    
RE: Single Row Function
select * from tbl_users where username like 'char ' and username like ' char'
 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 3Overall Rating: -1    
September 05, 2008 20:52:11   #4  
amitarudra Member Since: September 2008   Contribution: 4    
RE: Single Row Function
Select emp_name from employees where emp_name like 'a a';
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 3Overall Rating: -2    
September 25, 2008 06:26:25   #5  
me.ranjeet Member Since: September 2008   Contribution: 3    
RE: Single Row Function
Select * FROM TEST WHERE SUBSTR(NAME 1 1) SUBSTR(NAME -1 1)
 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 2Overall Rating: -N/A-    
December 11, 2008 04:33:38   #6  
PrernaK Member Since: December 2008   Contribution: 1    
RE: Single Row Function
Select * from emp
where upper(substr(ename 1 1)) upper(substr(ename -1 1))
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 2Overall Rating: -2    
December 18, 2008 19:55:32   #7  
serken Member Since: December 2008   Contribution: 8    
RE: Single Row Function
Negative argument for SUBSTR is not supported in standard SQL.
 
Is this answer useful? Yes | No
February 12, 2009 22:24:06   #8  
kgoyal15 Member Since: February 2009   Contribution: 1    
RE: Single Row Function
SELECT *
FROM table_users
WHERE (LEFT(name 1) SUBSTRING(name LEN(name) LEN(name)))
 
Is this answer useful? Yes | No
May 26, 2009 01:18:00   #9  
gtotten Member Since: May 2009   Contribution: 2    
RE: Single Row Function
select * from emp where left(name 1) right(name 1)
 
Is this answer useful? Yes | No
July 03, 2009 16:02:19   #10  
sivagarlapati Member Since: January 2007   Contribution: 18    
RE: Single Row Function
select emp_name from employee where emp_name like 'a ' and emp_name like ' a'
 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape