sql query for particular column i want to get all deatils from the data base

Question

0.00/5 (No votes)

See more:

select * from table name;

in the table all details are displayed. ok fine.

--course wise query

SQL

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

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.

Posted 17-Jan-13 2:26am

Member 8054539

Updated 17-Jan-13 3:05am

sisir patro

v2

Add a Solution

Comments

Zoltán Zörgő 17-Jan-13 8:30am

What about not adding where clause?
select Date,Session,Faculty_Code,Course from Tb_SCh_TIme_Table order by Date,session
This is what you have asked for. But I am afraid you want something else, but what?

[no name] 17-Jan-13 9:09am

Removing where clause will do your work. If your requirement is something different then let us know.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-01-17T03:02:00

Solution 1

Just remove the WHERE clause:

SQL

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

Posted 17-Jan-13 3:02am

OriginalGriff

VIPR@T · Answer 2 · 2013-01-17T03:45:00

Solution 2

Hi,

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

SQL

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

i hope this will help you.

Posted 17-Jan-13 3:45am

VIPR@T

sql query for particular column i want to get all deatils from the data base

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

sql query for particular column i want to get all deatils from the data base

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us