PASTEBIN
| #1 paste tool since 2002
create new paste
tools
api
archive
faq
PASTEBIN
create new paste
trending pastes
sign up
login
my alerts
my settings
my profile
Don't like ads?
PRO users
don't see any ads ;-)
Public Pastes
Untitled
1 sec ago
Untitled
2 sec ago
Untitled
3 sec ago
Untitled
7 sec ago
Untitled
28 sec ago
Untitled
Delphi | 8 sec ago
Parallels Desktop 8 Serial Key
2 min ago
Untitled
19 sec ago
Untitled
By: a guest on
May 1st, 2012
| syntax:
None
| size: 0.24 KB | hits: 26 | expires: Never
download
|
raw
|
embed
|
report abuse
|
print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
sql SELECT IN with like
select * from salary where employeename like (select name from employee)
select distinct s.*
from salary s
join employee e on s.employeename like '%' + e.name + '%'
select * from salary where emp_name like '%aj'
create a
new version
of this paste
RAW Paste Data
sql SELECT IN with like select * from salary where employeename like (select name from employee) select distinct s.* from salary s join employee e on s.employeename like '%' + e.name + '%' select * from salary where emp_name like '%aj'