1747. Leetflex Banned Accounts(SQL)

编程入门 行业动态 更新时间:2024-10-08 22:16:29

1747. <a href=https://www.elefans.com/category/jswz/34/1753482.html style=Leetflex Banned Accounts(SQL)"/>

1747. Leetflex Banned Accounts(SQL)

题目:/

Table: LogInfo

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| account_id  | int      |
| ip_address  | int      |
| login       | datetime |
| logout      | datetime |
+-------------+----------+
There is no primary key for this table, and it may contain duplicates.
The table contains information about the login and logout dates of Leetflex accounts. It also contains the IP address from which the account logged in and out.
It is guaranteed that the logout time is after the login time.
 

Write an SQL query to find the account_id of the accounts that should be banned from Leetflex. An account should be banned if it was logged in at some moment from two different IP addresses.

Ret

更多推荐

1747. Leetflex Banned Accounts(SQL)

本文发布于:2024-02-07 05:49:20,感谢您对本站的认可!
本文链接:https://www.elefans.com/category/jswz/34/1753647.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
本文标签:Leetflex   Banned   SQL   Accounts

发布评论

评论列表 (有 0 条评论)
草根站长

>www.elefans.com

编程频道|电子爱好者 - 技术资讯及电子产品介绍!