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 vote126 views1 answer
Insert or update cassandra
SQL
0 vote122 views1 answer
Oracle last character of string
SQL
2 votes129 views1 answer
Q operator in plsql
SQL
9 votes123 views3 answers
Mysql get last id
SQL
4 votes136 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote128 views1 answer
ALL_TAB_PARTITIONS
SQL
1 vote135 views2 answers
Begin transaction in sql
SQL
0 vote128 views1 answer
Sqlite select split string
SQL
0 vote121 views1 answer
How to search query in python3 sqlite3
SQL
0 vote128 views1 answer
Stored function in sql
SQL