Customer using hdfc bank sql query

select distinct u.name, u.address from users u
join bookingdetails b on b.user_id = u.user_id
where u.user_id not in 
( select user_id from bookingdetails where name='HDFC')
order by u.name;

Similar codes

0 vote322 views1 answer
Sql min
SQL
11 votes363 views2 answers
You are using safe update mode
SQL
0 vote396 views1 answer
Delete from IN subquery
SQL
0 vote346 views1 answer
QUERY JPQL
SQL
0 vote384 views1 answer
Hex string sql becomes int64
SQL
1 vote323 views1 answer
Can we drop a primary key
SQL
0 vote335 views1 answer
Check psql validity function
SQL
6 votes374 views3 answers
Mysql remove user privileges
SQL
1 vote375 views1 answer
Sql where max date
SQL
1 vote370 views1 answer
Primary key with prefix sql
SQL