如何从UserInfo表中获取名称，性别（男性和女性显示） [英] how to fetch Name,Sex from UserInfo table (male and female show alternatively)

问题描述

UserINfo表



如下表所示的选择查询是什么？

 + < span class =code-comment>  -    --- + -------- + ------- +  
 |  1  |女性|丽莎| 
 |  2  |男性|格雷格| 
 |  3  |女性|玛丽| 
 |  4  |男性|约翰| 
 |  5  |女性|珍妮| 
 +   -    --- + -------- + ------ -   
 
 
 Sql Query :: 选择 ID，名称，性别 from  UserINfo  order   by  ROW_NUMBER（） over （ PARTITION   BY 性别订单 按 Id），性别 asc  
 
我想使用  distinct   for 名称..什么是查询？ 
 和 如果 i 使用 内部  join 什么是查询

解决方案

尝试在此处添加您的表ID，

 选择 Id，姓名，性别来自 UserINfo  order   by  ROW_NUMBER （） over （ PARTITION   BY 性别< span class =code-keyword> order   by  Id），性别 asc  

（或）尝试分组

 选择 ID，名称，性别来自 UserINfo  group  按名称，ID，性别订单 按 ROW_NUMBER（） over （ PARTITION   BY 性别订单 按 Id），性别 asc  

试试这个：with Distinct function

 选择 不同 id，名称，性别，ROW_NUMBER（） over （ PARTITION   BY 性别订单  by  id） as  rows  from  UserINfo 订单 按行，性别递增 

UserINfo Table

what is the select query to show like the below table

+-----+--------+-------+
|   1 | female | Lisa  |
|   2 | male   | Greg  |
|   3 | female | Mary  |
|   4 | male   | John  |
|   5 | female | Jenny |
+-----+--------+-------


Sql Query:: select Id,Name,Sex from UserINfo order by ROW_NUMBER() over (PARTITION BY Sex order by Id),Sex asc

I want use distinct for Name..What would be the query? 
and if i use inner join what would be the query

解决方案

Try to add your table id here,

select Id,Name,Sex from UserINfo order by ROW_NUMBER() over (PARTITION BY Sex order by Id),Sex asc

(Or) try Group by

select Id,Name,Sex from UserINfo group by Name,Id,Sex order by ROW_NUMBER() over (PARTITION BY Sex order by Id),Sex asc

Try this : with Distinct function

select  distinct id,Name,Sex , ROW_NUMBER() over (PARTITION BY Sex order by id)as rows from UserINfo  order by rows,sex asc

这篇关于如何从UserInfo表中获取名称，性别（男性和女性显示）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！