Dql To Get The List Of Users Whose State Is Active And They Belong To

1.	Dql To Get The List Of Users Whose State Is Active And They Belong To Groups?
Answer» SELECT user_name, user_os_name, user_state from dm_user where user_state=0 and r_is_group=0 ORDER by user_name select user_name, user_os_name, user_state from dm_user where user_state=0 and r_is_group=0 order by user_name

Dql To Get The List Of Users Whose State Is Active And They Belong To Groups?

Answer»

SELECT user_name, user_os_name, user_state from dm_user where user_state=0 and r_is_group=0 ORDER by user_name

select user_name, user_os_name, user_state from dm_user where user_state=0 and r_is_group=0 order by user_name