sql查询特定列我想从数据库中获取所有deatils [英] sql query for particular column i want to get all deatils from the data base

问题描述

从表名中选择*;


表中的
显示所有详细信息。好的。



- 明智的查询

select * from table name;

in the table all details are displayed. ok fine.

--course wise query

select Date,Session,Faculty_Code from Tb_SCh_TIme_Table where Course='REO' order by Date,session

当我在特定课程上查询以上时REO我得到ouput.ok罚款。



日期Session Faculty_Code



2013-01-07 1 GS

2013-01-07 2 NR

2013- 01-07 3 RJ

2013-01-07 4 CM

2013-01-08 1 RK

2013-01-08 2 CM

2013-01-08 3 NR

2013-01-08 4 SJ



但我想要输出所有课程意味着我该怎么做才能写出查询适用于所有课程。



我该怎么办，所有课程详情都可以获得输出。



帮助我。

when i run above query for particular course REO i get the ouput.ok fine.

Date Session Faculty_Code

2013-01-07 1 GS
2013-01-07 2 NR
2013-01-07 3 RJ
2013-01-07 4 CM
2013-01-08 1 RK
2013-01-08 2 CM
2013-01-08 3 NR
2013-01-08 4 SJ

But i want the output for All course means how can i do to write the query for all course.

how can i do, for all course details to get the output.

help me.

推荐答案

只需删除WHERE子句：

Just remove the WHERE clause:

SELECT Date,Session,Faculty_Code FROM Tb_SCh_TIme_Table ORDER BY Date,session

您好，



只需从查询中删除where条件。

这样您就可以获得所有课程的详细信息。

Hi,

Just remove the where condition from the query.
so you can get the all course detail.

select Date,Session,Faculty_Code from Tb_SCh_TIme_Table order by Date,session

i希望这对你有帮助。

i hope this will help you.

这篇关于sql查询特定列我想从数据库中获取所有deatils的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！